Skip to main content

Varicent ELT Help Center

SQL Server

Abstract

Connect your Varicent ELT and SQL Server accounts to export your data to your SQL Server account. This connection lets Varicent ELT to write data to your SQL Server.

Connect your Varicent ELT and SQL Server accounts to export your data to your SQL Server account. This connection lets Varicent ELT to write data to your SQL Server.

Create the connection

Create the connection between Varicent ELT and your SQL Server. Generate a new SQL Server connection, or use an existing one.

Creating a new connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the connection drop-down.

  4. From the connection drop-down, click + New connection.

  5. Create the new SQL Server connection for the Export tool.

    1. On the Connect to your Database page, enter the following information:

      Table 31. SQL Server

      Field

      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.



  6. Click Export now.

    You will be redirected to the Create an Export pane. For more information, see Exporting data.

Using your existing SQL Server connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration, click the Connection drop-down.

  4. Search for and select your existing SQL Server connection.

  5. Select the table name to export.

  6. Click Export now.

    You will be redirected to the Create an Export pane. For more information, see Exporting data.