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.
-
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 Microsoft SQL Server, follow these steps:
to fetch data from-
In the Authorization step of the datastream wizard, click Access Microsoft SQL Server using your credentials.
-
Click Next.
-
In Hostname, enter the server name of the database from which you want to collect data.
-
In Database, enter the name of the database from which you want to collect data.
-
In Username, enter your Microsoft SQL Server account user name.
-
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 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:
-
(Optional) Rename your datastream.
-
In Table, select the table from which you want to collect data.
-
In Query, enter an SQL query defining the data that you want to fetch.
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice