Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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

  • No labels