Components

Back Next

Configuring a saved query

Create a saved query that you can use as a source object in

synchronization

tasks or as a query in SQL transformations.

Click

New

Components

Saved Query

and then click

Create

To edit a saved query, on the

Explore

page, navigate to the saved query. In the row that contains the saved query, click

Actions

and select

Edit

Enter the following details:

Detail	Description
Saved Query Name	Name of the saved query. Query names can contain alphanumeric characters, spaces, and the following special characters: _ . + - Maximum length is 100 characters. Query names are not case sensitive.
Location	Location of the saved query. Browse to the folder where you want to store the saved query or use the default location. If the Explore page is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description	Description of the saved query. Maximum length is 255 characters.
Database Type	Source database type. Select one of the following database types: Salesforce Oracle SQL Server MySQL ODBC MS Access To use the query in an SQL transformation, the database type must be Oracle or SQL Server.
SQL Query	SQL statements that make up the SQL query. To use the query as the source in a synchronization task, enter a SELECT statement. Data Integration uses the SELECT statement to retrieve the source column information. To use the query in an SQL transformation, enter one or more valid SQL statements. Do not use SQL transformation parameter binding or string substitution notation in the query because saved queries have no information about SQL transformation input fields.