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.

  • Microsoft SQL Server can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

  • 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 Creating a datastream. 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.

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

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

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

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

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.

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

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

What's next?