Creating load queries
The Load
Queries tab lists existing load queries. You can select an existing
query or create a new one.
- Select Dashboards > Data Integrations > Relational Modeling.
- In the Target Connection field, select the database to which to load data.
- Select the table into which to load data and click the Load Queries tab.
- Select your application from the Application list.
- Click Add.
-
Specify a name for the query or retain the default.
Note: You cannot change the name at a later time.
- In the Source Connection field, select the data connection that connects to the source database.
- Optionally, specify a description of the load query.
-
If the target connection is Staging, and the table has a
primary key, select one of these options to determine how duplicates of primary
key values are handled during data loading:
Option Description Update Overwrite existing values Skip Retain existing values Abort Abort the data load if a primary key is duplicated These options are not displayed for integration target tables. -
In the Query Editor, specify an SQL SELECT statement to query
the data to load.
You can double-click objects in the object browser to add them to your query. Double-clicking a column in the target adds the column name as an alias. For example
AS [PersonID]
. Double-clicking In the source adds the column name.Note: Load queries can be parameterized with the use of custom settings. Relational modeling automatically translates custom settings to SQL parameters. This eliminates the risk of SQL-injection.Use this syntax to incorporate a custom setting into a load query:
For example:@CustomSettings.<setting_name>
select * from Table where ModifiedDate > @CustomSettings.LoadFromDate
- Click Save.