Components > Saved queries > Configuring a saved query

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.
    1. 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.
    2. Enter the following details:
    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 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 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.
    3. If you enter a SELECT statement, click Get Columns and select a connection.
    The Saved Query Column Details table displays the columns selected in the SQL statement.
    4. Optionally, in the Saved Query Column Details table, edit the data type, precision, or scale.
    If you edit these values, Data Integration does not write error rows into the error rows file.
    5. Click Save.