Collecting data from Database
This guide explains how to collect data from Database. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.
Creating a datastream to collect data from Database
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 Database.
Configuration: Choose the data you want to collect from Database
To choose what data to collect and customize the Database datastream configuration, follow these steps:
-
(Optional) Rename your datastream.
-
In Engine, select the SQL engine type from the drop-down list.
-
In Hostname, enter the hostname of the SQL Database. If you use a port other than the default setting for the selected SQL Database, enter the port in the format
hostname:port
. -
In Database, enter the name of the database from which you want to collect data.
-
(Optional) In Incremental Fetch Column, enter the name of the column for which to perform incremental fetches. Once the fetch is completed, the field with the placeholder
@dt_last_fetch_max
is populated with the maximum value collected during the last fetch. -
In Connection args, enter the arguments to use to collect data.
-
In Query, enter the database query to use to collect data. See the helptext beneath the Query field for a list of available placeholders.
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