Hi
Please try the below steps
Example: Loading Data from BODS to Snowflake
1. Install the Snowflake ODBC Driver
Download the Snowflake ODBC driver from the Snowflake website.
Install the driver on the machine where BODS is running.
2. Configure ODBC Data Source
Open the ODBC Data Source Administrator on your machine.
Go to the System DSN tab and click Add.
Choose the Snowflake ODBC Driver and click Finish.
Enter the DSN Name (e.g., SnowflakeDSN), and provide the following details:
Account: Your Snowflake account name.
Warehouse: The Snowflake warehouse you will use.
Database: The Snowflake database name.
Schema: The schema where the data will be loaded.
Test the connection to ensure it works, then Save the DSN.
3. Open BODS Designer
Launch SAP BusinessObjects Data Services Designer.
4. Create a Data Store for Snowflake
In BODS Designer, navigate to Data Stores.
Right-click and select New Data Store.
Choose ODBC as the type of data store.
Enter a name (e.g., Snowflake_Store).
Click Next and select the DSN you created earlier (SnowflakeDSN).
Enter your Snowflake username and password.
Test the connection to ensure it works.
5. Create a Data Flow
Create a new Data Flow in BODS Designer.
Add a source object (e.g., a table or query from your source database).
Add a target object and choose the Snowflake data store (Snowflake_Store).
Map the fields from your source to the target table in Snowflake.
6. Configure and Run the Job
Create a new Batch Job in BODS.
Add your data flow to the job.
Schedule or manually run the job to execute the data flow.
Monitor the job execution and check for any errors.
Conclusion Finally: Install Snowflake ODBC driver.
Configure ODBC DSN with Snowflake details.
Open BODS Designer and create a new ODBC Data Store.
Set up data flow from source to Snowflake target.
Run the job to load data into Snowflake.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.