When you choose Relational Database as the data source, you can create a data source from SQL-based and other dynamic databases.

Provide all the necessary information to connect to a relational database query a subset of data. Note that mandatory entries are indicated in red.

Provider

Select the data source provider from the dropdown list. Example: Microsoft SQL Server OLEDB or ODBC. If the one you are looking for is missing, contact your system administrator. The list of providers is based on the providers that are installed on the Necto server machine.

Driver

Select the compatible driver (installed on the Necto server) for the provider. Example: Microsoft OLE DB Provider for SQL Server.

If you haven’t installed the driver yet, use the button next to this field to perform the installation.

Server

Enter the database server instance.

Additional Properties

Enter the User Name and Password, and additional properties for each type of data source, in order to create a valid connection string.

Database

From the dropdown list, select a database to access.

Extended Properties

Additional connection string properties that are needed, and that do not exist in this dialog box. These properties need to be entered in a valid syntax: “Parameter=Value; …”

Connection String

The connection string to the database built from the properties you have supplied.

Click  to verify the connection string syntax.

Click Next to continue to saving the data source.