SAP S4 is an enterprise resource planning system. It consists of built in Business Intelligence and Machine Learning functionalities.
Sprinkle now supports SAP as a data source. On clicking the "+sign" a list of data sources appears. In this case, SAP is selected. A new SAP data source is named and created.
To create a connection, the user needs to provide a JDBC URL which consists of the “Host” and “Port” values. In the next field, the name of the database you need to connect with is applied. Post this, the database username and password is provided. Name of the schema which contains the table to be ingested is provided in the next field.
Optimising Incremental Ingestion in SAP
Also users can select Yes or No to Optimize Incremental Ingestion. If optimize is Yes, all the datasets will undergo full ingestion on every Sunday or every night. If optimize is No, data will be ingesting incrementally and it never goes under complete ingestion. Incremental and Complete ingestion.
In Add Tables, the user can add tables either by “Table” or “Query” method, in table method the user is required to apply a table name and filter clause could also be applied whenever required.
The users can select the mode of ingestion, exclude particular columns from the ingestion table and also mask column data using SHA256 algorithm.
On selecting Query, the user must provide a table name and apply Query before creating a table.
In the Ingestion Jobs tab, the concurrency (number of tables that can run in parallel, a maximum of 7) can be set preferentially before running the job. The status of the job will be updated in the tab below once it’s complete. The jobs can also be set to run automatically by enabling autorun. Frequency can be changed by clicking on More --> Autorun-->Change Frequency.