1. Using the SAP ASE (Sybase) Adapter with Oracle Integration Generation 2
  2. Add the SAP ASE (Sybase) Adapter Connection to an Integration
  3. Invoke Operations On Table Page

Invoke Operations On Table Page

Select the database tables. To use the bulk extract feature, you must choose the SELECT operation from the Perform an Operation On a Table list on the Basic Info page.

Operations on Table Page

Element Description
Schema Select the database schema that includes the tables to process.
Table Name Enter a filter with which to search the schema (for example, %TAB to search for tables with TAB in the name).
Table Type

Specify the table type filter to get a subset of the appropriate database objects, then click Search.

  • ALL
  • TABLE
  • VIEW
Filter By Enter the initial letters to filter the display of table names.
Available Lists the tables that meet the selection criteria.
Selected Lists your table selection.
Import Tables Click to import the tables. The page is refreshed for you to select the parent database table.
Primary Keys

Appears when you select tables without a primary key defined. Select the virtual primary key for the table.

Note: Having the primary key at the database level is the best practice.

Select the parent database table Select the parent (root) table from the list. If using multiple related tables, this is the top-level parent table in the relationship. After making your selection, the page is refreshed for you to view and edit the table relationships.
Add || Remove Tables Click to add more tables or remove tables no longer in use.
Review and manage parent database table relationships Click Edit to view and edit the table relationships. The relationships automatically identified by the adapter are displayed. See Review and manage parent database table relationships Option.
Review and filter columns from selected database tables Click Edit to view and edit the table attributes. You can deselect any attributes to exclude from the database queries. Primary key attributes cannot be excluded. See Review and filter columns from selected database tables Option.
Review and edit SQL query

(Displayed only if the Select operation is selected on the Basic Info page.)

Click Edit to view and edit the default SQL query. See Review and edit SQL query Option.

Review and manage parent database table relationships Option

Review and manage the parent database table relationships.

Element Description
Create New Click to create a new relationship.
Parent Table Select the parent table.
Child Table Select the child table.
Relationship

Select the relation type (one-to-many, one-to-one, or one-to-one with the foreign key on the child table). For example, if you selected Employees as the parent table and Departments as the child table, the following options are displayed:

  • Employees has a 1:1 Relationship with Departments
  • Employees has a 1:1 Relationship with Departments (Foreign Key on Child table)
  • Employees has a 1:M Relationship with Departments
Attribute Name Applies attributes to the table relationship.
Mapping Displays the mapping for the table relationship.
Detach Opens the Relationships list in a new window.

Review and filter columns from selected database tables Option

Review and filter columns from the selected database tables option.

Element Description
Attributes Tree View and deselect attributes automatically created by the adapter. Deselect any attributes to exclude from the database query.

Review and edit SQL query Option

Review and edit the SQL query.

Note:

This is only applicable for a Select operation on a table.
Element Description
SQL Edit Click to manually edit the query in the SQL Query field.
Edit using Expression Builder Click to edit the query in the Expression Builder.
  • Add New: Click to add new criteria to the SQL query.
    1. Click Add New.
    2. In the First Argument field, click Edit, and select the argument to add (for example, deptno).
    3. In the Operator field, select the operator to use for the comparison from the dropdown list (for example, EQUAL).
    4. In the Second Argument field, select the option to use:
      • Literal: Click to specify a value. If selected, you are prompted to select the data type (for example, integer) and specify the value.
      • Parameter: Click to specify a bind parameter.
      • Query Key: Click to run the comparison against another column in the table.

    New criteria is appended to the SQL query with a WHERE clause. If you add subsequent SQL queries, they are appended to the SQL query with an AND clause.

  • Add Nested: Click to add nested criteria to the SQL query.
  • Edit: Click to edit the SQL criteria you specified.
  • Remove: Click to remove the SQL criteria you specified.
Maximum Number of Records to be fetched Select the number of records to fetch with this SQL query.
Enable Pagination Select the checkbox. When you must fetch a large number of results/records, you can implement the SAP ASE (Sybase) Adapter’s pagination feature and receive sorted results/records in chunks. Offset and Limit fields are displayed in the mapper. You can specify the number of results per page by providing the offset and limit values according to your requirement. Enter a starting value in the Offset field and an end value in the Limit field to receive sorted results.