Creating Native Queries For Microsoft SQL Server

For Connectors that support native languages, such as Microsoft SQL Server, use the Native Query Block in a Map to write your own free form query.

When you write a native query, the following rules apply:

When testing a Native Query in a Map, if the source datastore does not return any data, TIBCO Scribe® Online cannot build the schema for the underlying metadata and the Map cannot be saved. To allow TIBCO Scribe® Online to build the schema, do the following:

  1. Create a single temporary record in the source datastore that matches the Native Query.
  2. Test the Native Query and ensure that it is successful.
  3. Save the Map.
  4. Remove the temporary record from the source datastore.

Related Topics

Defining An Integration Map

Query Block

Block Properties Filter Tab

Control Blocks