Mapping a Source to a Destination
To map a source to a destination, select or enter the name of the source object (From) and the name of the destination object (To). If either the source or the destination (or both) are linked to a live connection, Integrator can automatically populate object names by reading metadata (table names, files names, API endpoints, etc.) directly from the data source.
If the object name is not available in the drop-down, click the
Clear Cache button at the bottom of the screen. Integrator will reconnect to the data object and attempt to reread the metadata. You can always manually enter the object name in this field.
Selecting Source and Destination objects from the list.
If the source and/or destination is connected to the live connection, the system will automatically populate available objects (tables, files, endpoints) from the specific connection. Use metadata selector to select an object from the list.
A source query is an SQL query which extracts data from the source object. If the source is an SQL database, simply enter the SQL query using the SQL dialect supported by that particular database. In addition to SQL databases, Integrator supports running SQL queries against almost any data object. Read how to execute SQL queries against files and API endpoints.
When loading data into a database, Integrator will either automatically generate and execute an SQL DML statement (INSERT, UPDATE, DELETE or MERGE) or execute a user-created SQL.
When the destination is a relational database, the user has two options:
- Use the To field to select or enter the database object name (table, view, synonym).
- or enter an actual Destination query.
Read more about destination queries.
This field is available only if the destination is an SQL database.