Pages

BICS Data Loading Using Data Sync Tool

Download Data Sync Tool Here

You need to download and configure the Data Sync tool, and create a repository.

and then login to repository.


Create a project


Create a new connection and give source details.


Click on TARGET and give BICS schema details.


Now Click on Projects Tab, 
To import data from relational db > click on Relational Data tab > click on Data from Table.

You will get below window.



Select the tables you need to load and click import.



You can see the imported tables in the same window.



Now click on Jobs tab. and you can see the job is created automatically.

just click on Run Job button.


your data will be loaded to BICS schema. the time duration is based on the volume of data.

Happy learning. :)



BICS Data Loading Using Data Sync Tool

Download Data Sync Tool Here

You need to download and configure the Data Sync tool, and create a repository.

and then login to repository.


Create a project


Create a new connection and give source details.


Click on TARGET and give BICS schema details.


Now Click on Projects Tab, 
To import data from relational db > click on Relational Data tab > click on Data from Table.

You will get below window.



Select the tables you need to load and click import.



You can see the imported tables in the same window.



Now click on Jobs tab. and you can see the job is created automatically.

just click on Run Job button.


your data will be loaded to BICS schema. the time duration is based on the volume of data.

Happy learning. :)



Featured post

Snowflake - Creating warehouse in Snowflake

Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...