SAP Netweaver Connector - passing parameters to the RFC Function

Matillion ETL
1

I have been able to get a connection to the SAP Netweaver created and hit the tables I am after. However the standard RFC_READ_TABLE function limits row length to 512 bytes and a lot of tables have more. Rather than splitting in to multiple extracts and joining (fallback) I'd prefer to use a custom RFC (Z_Z_RFC_READ_TABLE). I can call this by putting into the connection options.

 

However, unlike the standard program which correctly aligns the columns based on length, the custom program has a parameter that will either space out the fields, or condense. The default is to condense which means the read into Matillion is corrupted as everything is misaligned.

 

Is there a way in Matillion to pass the parameter value to the RFC function in SAP. I can't see where this might be done.

 

My fallback is to do multiple reads, or create a new custom function variant but rather not do these if possible.

 

Thanks,

Michael

2

Note: Workaround was to create an alternate custom RFC function to force fixed column widths as the Matillion Connector doesn't support parameters.