This section contains information that is specific to the database type SQL Server.

Supported Functions

The SQL Server database can be used with:

Audit Profile
Database Bulk Lookup Functions (APL)
Database Table Related Functions (APL)
Database Collection/Forwarding Agents
Event Notifications
Prepared Statements (APL)
SQL Collection/Forwarding Agents
Task Workflows Agents (SQL)

Note!

For SQL Server, the column type timestamp is not supported in tables accessed by . Use column type datetime instead. See also the System Administration Guide for information about time zone settings.

Preparations

The drivers that are required to use SQL Server database are bundled with the software and no additional preparations are required.

Advanced Connection Configuration for SQL Server

If required, you can set the selectMethod when you select the Advanced Connection Setup option.

By default, the selectMethod property on all connections towards the SQL Server type of database is set to cursor. If required, you can set the property to direct by selecting the Advanced Connection Setup option, and entering a connection string manually. For example, if you require to use direct mode, you can add a connection string that will create connections using selectMode direct, as shown in the image below.

Advanced Connection Setup for SQL Server