Page tree
Skip to end of metadata
Go to start of metadata

 Back


SQL Server - InMemory Assembly

The SQL Server assembly can connect to a Microsoft SQL Server database and read data from the available tables.

Adding the Data Source

The SQL Server assembly is a ‘TARGIT’ data source.

Name

Enter a unique name for this data source. This is the name of the data source as it will appear in the Data Sources list in TARGIT Data Discovery.

Server

Enter the name of the server hosting the SQL Server you would like to connect to.

Use Windows Authentication

If checked, you must make sure that the service account running the TARGIT InMemory Scheduler Service is an account that has access to the SQL Server.

If unchecked, you must provide username and password of an account that has access to the SQL Server.

Database

Once server name and account information have been validated, you will be able to look up and select a database from the drop down list. You may need to click the 'Update' button before the drop down list is populated.

Connection string

The connection string is auto-generated from the other settings and is usually used as such. However, you have an option to change the connection string and thereby further customize your settings.


  • No labels