SQL Login

This table describes the SQL Login properties:

Field Description
Server Type

Database server type.

The remaining fields change based on the selection:

 

Server Type

Field(s)

Description

Microsoft SQL Server

Server

MSSQL server name.

 

Authentication

Security type: SQL Server or Windows Authentication.

 

Login

Login ID.

Oracle

Instance name

Oracle instance name.

Other SQL Server

Connect String

Connection string used to connect to the server.

JDBC

Driver

JDBC driver that will be used to connect to the database.

 

URL

URL used to connect to the database.

PostgreSQL Instance Name

Instance Name should be in the format -

'Servername:Databasename'

  Port Port number configured for PostgreSQL. The Default Port number is 5432.
  Login PostgreSQL Login ID to the Database.
Allow token access Allow the login properties to be used as tokens within the attributes of a task.