Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

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:
    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.
  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
    .


Updated August 03, 2020