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

 Back


SQL Server - Data Discovery Plugin

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

Adding the Data Source

The SQL Server plugin is a 'Databases' 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 Data 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.

Table

Once a database has been selected, you will be able to select a table from the drop down list.

SQL Command

The default SQL Command will be to select all (select *) from the selected table. However, you can enter any valid select statement in this box to produce an output.

Example: SELECT [Code], [Name], [E-Mail], [Job Title] FROM [Stage].[dbo].[Salesperson] WHERE [Job Title] = 'Manager'

Schedule

Click the ‘Set’ button to configure how often to check this data source for updated data.

The scheduling options can be set to: Minutes, Hourly, Daily, Weekly, Monthly or Yearly.


  • No labels