Fast and easy import of Exact Online data to SQL Server using SQL Server Integration Services (SSIS) and Invantive Cloud.
SQL Server and other database platforms can be used to store data from over 1140 Exact Online tables. The SQL Server database can be used as source for interactive applications, backup, datawarehouse for analytics or reporting datamart. Depending on the requirements, a daily refresh of a single Microsoft SQL Server table or a continuous process uploading Exact Online data is are possible.
The setup page explains how to load data into SQL Server using SSIS in Visual Studio and Invantive Cloud from Exact Online in five minutes.For use with Power BI, Power Query, Qlik and Tableau you can also direct load the data without intermediate SQL Server database using Invantive Cloud.
The following link describes the 1140 availables Exact Online tables: