Retrieve InforDatafabric data to SQL Server data

Rajini

Hello Everyone,

I am looking for how to send a data fabric/data lake table data to Database table?

1. Retrieve from Data Lake Activity
2. Utilize ION Scripting to transform the data from JSON format to XML.
3. Establish a connection to the database and insert the transformed data into the target table via a stored procedure.

Does this approach work? or would you like to explore other methods?

Could you please guide me on this.

Regards,

Rajini

Bojan Rafajloski

Hi Rajini,

It is correct that with ION Data Lake Flows you must utilize stored procedures to load data in a database connection point. Please ensure that you are also following Variation Handling concepts when loading the data to ensure that you are only updating target records when the variation of the record being loaded is higher than the variation of the existing records in the database.

However, that may not be the most efficient option as you have to deal with stored procedure.

In relation Infor offers other tools that can integrate directly with SQL Server databases.

From April 2025, Data Fabric Pipelines will support streaming real-time data to AWS RDS for SQL Server and Azure SQL Database.

Additionally, as Enrico mentioned, the ETL Tool can also be used for scheduling data extraction from Data Lake to load it in a SQL Server.

Please check the 'Advanced Data Fabric' training in the Infor Education (Infor U) portal. It contains information about both these features. Both of these tools follow Data Fabric data concepts to ensure data is deduplicated in the target and only updated with the latest version of the records.

Note that Pipelines and ETL Tool require additional licensing and are not included in the standard OS license.

Additionally, you can always use 3rd party tool or service to integrate with our APIs and implement a custom solution to ETL data to your systems.

If you would like to explore the data extraction options that Infor offers that fit your use case please reach out to your Infor representative to schedule a session with an Infor technology solution consultant.