Creating load queries

The Load Queries tab lists existing load queries. You can select an existing query or create a new one.
  1. Select Dashboards > Data Integrations > Relational Modeling.
  2. In the Target Connection field, select the database to which to load data.
  3. Select the table into which to load data and click the Load Queries tab.
  4. Select your application from the Application list.
  5. Click Add.
  6. Specify a name for the query or retain the default.
    Note: You cannot change the name at a later time.
  7. In the Source Connection field, select the data connection that connects to the source database.
  8. Optionally, specify a description of the load query.
  9. 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.
  10. 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:
    @CustomSettings.<setting_name>
    For example:
    select * from Table where ModifiedDate > @CustomSettings.LoadFromDate
  11. Click Save.