Skip to main content

Symon.AI help center

SQL Server

Abstract

Connect your Symon.AI and SQL Server accounts to export your data to your SQL Server account. This connection lets Symon.AI to write data to your SQL Server.

Connect your Symon.AI and SQL Server accounts to export your data to your SQL Server account. This connection lets Symon.AI to write data to your SQL Server.

Create the connection

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

Creating a new connection

  1. In Symon.AI, 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 26. 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 Symon.AI, 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.