Basic Info Page

Specify a name, description, and operation type on the Basic Info page of each invoke connection in your integration.

Element Description

What do you want to call your endpoint?

Provide a meaningful name so that others can understand the connection. For example, if you are creating a database connection for adding new employee data, you may want to name it CreateEmployeeInDB. You can include English alphabetic characters, numbers, underscores, and dashes in the name. You cannot include the following:

  • Blank spaces (for example, My DB Connection)

  • Special characters (for example,  #;83& or righ(t)now4)

  • Multibyte characters

What does this endpoint do?

Enter an optional description of the connection’s responsibilities.

What operation do you want to perform?

(Note: This option is only displayed when you configure the Netezza Adapter as an invoke connection in an integration.)

Select the type of operation for this connection to perform:

  • Invoke a Stored Procedure: Select to invoke a stored procedure in the database.
  • Run a SQL Statement: Select to run a SQL query against the database.

  • Perform an Operation On a Table: Select to perform one of the following operations on a table.

    • Insert

    • Update

    • Insert or Update (Merge)

    • Select

  • Perform Bulk Data Import Operation: Select to import bulk data into the Netezza database.