How Can I Sync Decoded SAP Long-Text Data to Snowflake?

Question

I use the SAP READ_TEXT function module to retrieve long text, but it doesn't write the decoded text to a database table. How can I use Fivetran to sync readable long-text data to Snowflake?

Environment

• Connector: SAP ERP on HANA
• Connection mode: NetWeaver
• Destination: Snowflake

Answer

To sync readable SAP long-text data to Snowflake:

1. Confirm that the Fivetran NetWeaver API is installed in your SAP system.
2. In Fivetran, go to your SAP ERP on HANA connection page.
3. Select the Schema tab.
4. Select the checkbox next to the STXL table.
5. Click Save changes.
6. In the top right, click Sync. Alternatively, trigger a table-level re-sync.

We unpack the STXL data during the sync and write the decoded text to the /FIVETRAN/STXL_TEXT column in Snowflake.

Limitations

We don't support long-text values larger than 2 GB due to an SAP limitation. When you use History Mode, long-text rows include the standard Fivetran metadata columns.

We don't support unpacking for connections using the HANA Database (direct) connection mode. For more information, see our SAP ERP on HANA documentation on unpacking data.