SQL Server
Connect your Varicent ELT and SQL Server accounts to import your data.
Connect your Varicent ELT and SQL Server accounts to import your data.
In Varicent ELT, go to the Data tab.
Click Import data.
In the Third party sources section, click SQL Server.
Click New connection.
On the Connect to your Database page, enter the following information:
Table 22. SQL ServerField
Description
Connector name
The name of the connection.
Host
The URL of the host.
Port
The port number.
Database
The name of the database.
Username
The SQL Server user name.
Password
The SQL Server password
Click Next.
On the Select data page, choose the file from the Directory drop-down field.
Click Next.
On the Choose data sets page, select which data sets that you want to include. If you want to obfuscate any data, select the data sets to obfuscate.
Click Next.
On the Filter data page, optionally click Filter data to refine your data, or click Import data to continue.
Filter the rows in your data by selecting the column to filter, the filter category and the value or text.
Click Import data to continue.
Note
For more information about how to configure data filters, see: Filter data.
On the Review page, review the data sets that you are importing.
Click Import data.
The data is available on the My Data page.