для Cisco Cisco Process Orchestrator 3.0

1-3

Cisco TEO Adapter Guide for Microsoft SQL Server Database

OL-24576-02

Chapter 1 Configuring SQL Server Database Adapter

Configuring Microsoft SQL Server Database Adapter Properties

The SQL Server Database Adapter provides the activities to access SQL Server database objects and
execute SQL queries in TEO. Use the SQL tab to configure SQL Server database query settings.

To configure SQL Server database:

Step 1

In the Administration—Adapters view, right-click Microsoft SQL Server Database Adapter and
choose Properties.

The Microsoft SQL Server Database Adapter Properties dialog box displays.

Step 2

Click the SQL tab to continue.

Figure 1-2

Microsoft SQL Server Database Adapter Properties—SQL Tab

Step 3

On the SQL tab, specify the following information:

Step 4

Click OK to close the dialog box.

Field

Description

Maximum number of rows

Maximum number of rows to return in a Select SQL query
(default: 10000)

Common termination characters are forward slash [ / ] and
the semi-colon [ ; ]. SQL Server supports the semi-colon

[ ; ] and GO.

Termination character

Termination character string with default values