Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Prerequisites

  • Basic knowledge of Arm Treasure Data.

  • A SQL Server instance.

Use the TD Console to Export Results

  1. Open the TD Console.

  2. Navigate to Data Workbench > Queries.

  3. Create a new query or select an existing query.

  4. Select Export Results.

  5. The Choose Integration dialog opens. Select one of two options:

    1. Use Existing Integration. Select the existing integration.


    2. Create New Integration. Select the integration type and edit the integration Name, Host, User, and Password.


      • If you are using Azure, omit the instance name and provide the port # only.

      • If you are not using Azure and want to use your own instance: make sure that you can connect to the database using only the instance name, without the port. The reason for this is that when port is set, the instance name will be ignored. The `JDBC` library does not try to resolve from name → port but instead uses the port in configuration. Check with a database connector tool without using the given port.

  6. Save the query with a name and run, or just run the query. After successful completion of the query, the results are exported to the specified SQL Server destination.

...