After setting up your source application in Step 1 of creating a Celigo sync, continue with Step 2: Destination.
-
Select NetSuite Analytics Warehouse (NSAW) from the endpoints listed in Choose destination. (Instructions for other destination endpoints and optimizing ingestion appear in this Help Center category.)
-
Choose an existing connection to NSAW, or you can click Create connection to define a new resource that you can use here and in other syncs, flows and APIs.
Tip
Selecting the same connection used in a flow may slow performance if this sync is scheduled to run at the same time as the flow.
An online connection provides the wizard with the list of databases in your NSAW account.
-
Select the database where the source data will be ingested.
-
Enter characters that will be prepended to the names of tables created in the destination database. A table “prefix” is a human-readable label at the start of a table name that indicates the type or source of the data it holds.
-
Give the schema a unique and meaningful name, for use in identifying new destination tables that belong to this schema.
Note
-
This schema name is for use only with this sync.
-
You may enter the name of a schema that exists at the destination, but only this sync can write to it.
-
Be careful when entering a schema name; you won’t be able to edit it after you save and run the sync.
-
Tables created by this sync will be named as follows:
<database>.<schema>.<prefix><table>
Where...
-
You selected
<database>above -
You entered a
<schema>name above -
You entered a
<prefix>above -
<table>reflects an object/export that you selected or a table name you entered for an export
Then, click Next to save your sync destination and continue with Step 3: Settings.