Basic Information Page

The Basic Info page appears when you drag an adapter onto the integration canvas. Review these topics to learn more about Microsoft SQL Server Adapter basic information settings.

Element Description

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 operation do you want to perform?	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. You can update or insert multiple records in a single request. Insert Update Insert or Update (Merge) Select Note: When operations in a SQL statement such as Update, Concat, and Merge accept values for the inbound invocation of an integration, they do not work. For example, the following query does not work: `select concat(empname, 'ss') from DB_AQ where empno=#empno` `select empno from DB_AQ where empname=concat(#empname, 'YY')` As a workaround, handle these scenarios during payload mapping. For example, perform a concatenation during mapping of the payload. The final output can then be passed as input to the SQL query.

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 operation do you want to perform?

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. You can update or insert multiple records in a single request.
- Insert
- Update
- Insert or Update (Merge)
- Select

Note: When operations in a SQL statement such as Update, Concat, and Merge accept values for the inbound invocation of an integration, they do not work. For example, the following query does not work:

select concat(empname, 'ss') from DB_AQ where empno=#empno

select empno from DB_AQ where empname=concat(#empname, 'YY')

As a workaround, handle these scenarios during payload mapping. For example, perform a concatenation during mapping of the payload. The final output can then be passed as input to the SQL query.