Setting up connection with Snowflake
In Celigo NetSuite - Snowflake ETL tile, Navigate to “Connections” (as you can see in the image) from the tabs available.
In the “Connection” tab, There will be an option to create a new connection(“Create Connection”). Once we click that a new window slides onto the screen.
Let’s find what each field needs as information.
- Name* : Name of the connection
- Account name* : This is where we place the base URI of the snowflake account.
- Database name* : Input the name of your database from the snowflake account.
- Warehouse name* : Input the name of your warehouse from the snowflake account.
- Schema : Name of the schema which has been created for the database in your snowflake account.
- User Role : Name of the user account / profile of your snowflake account.
- Username* : Profile name (used for login).
- Password* : Password used for logging into that snowflake account.
Once we fill in all the required fields, Then click on “Test Connection” to test the connection with regards to the information provided in the form.
If everything is accurate and correct then we will get a green tick alert prompt confirming the details are correct. If we get a red box alert then, Re-check with all the details.
Once it is successfully established, Save and close the connection floating window.
Setting up connection with NetSuite
In Celigo NetSuite - Snowflake ETL tile, Navigate to “Connections” (as you can see in the image) from the tabs available.
In the “Connection” tab, There will be an option to create a new connection (“Create Connection”). Once we click that a new window slides onto the screen.
Let’s find what each field needs as information.
- Name* - Name of the connection
- Authentication Type* - Token Based Auth (Manual)
- Environment - This is optional as per your business requirements, If setting up in sandbox then choose “Sandbox”. Else if the environment is production then choose “Production”
- Account Id* - Input the account id from your Netsuite account profile.
- Token ID* - Once the tokens are created in Netsuite, The “Token ID” must be added here.
- Token Secret* - The “Token Secret” will be added to this field.
Once we fill in all the required fields, Then click on “Test Connection” to test the connection with regards to the information provided in the form.
If everything is accurate and correct then we will get a green tick alert prompt confirming the details are correct. If we get a red box alert then, Re-check with all the details.
Once it is successfully established, Save and close the connection floating window.
