Collecting data from Microsoft SQL Server

Collecting data from Microsoft SQL Server#

This guide explains how to collect data from Microsoft SQL Server. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

Prerequisites#

Before you start collecting data from Microsoft SQL Server, perform all of the following actions:

  • Ensure that the IP of your Adverity instance is whitelisted by the database to which you want to connect.

Creating a datastream to collect data from Microsoft SQL Server#

The basics of creating a datastream to collect data from any data source are explained in our guide to Collecting data in Adverity. This guide contains information about the specific steps to create a datastream to fetch data from Microsoft SQL Server.

Authorization: Allow Adverity to access Microsoft SQL Server#

To set up a new authorization to fetch data from Microsoft SQL Server, follow these steps:

  1. In the Authorization step of the datastream wizard, click Access Microsoft SQL Server using your credentials.

  2. Click Next.

  3. In Hostname, enter the server name of the database from which you want to collect data.

  4. In Database, enter the name of the database from which you want to collect data.

  5. In Username, enter your Microsoft SQL Server account user name.

  6. In Password, enter your Microsoft SQL Server account password.

Note

The user name and password of the account must come from Microsoft SQL Server. If you use a username and password from any other application, the authorization will fail.

Configuration: Choose the data you want to collect from Microsoft SQL Server#

To choose what data to collect and customize the Microsoft SQL Server datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  2. In Table, select the table from which you want to collect data.

  3. In Query, enter an SQL query defining the data that you want to fetch.

What’s next?#

Contents