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 Collecting data in Adverity. 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:

1. (Optional) Rename your datastream.

2. In Engine, select the SQL engine type from the drop-down list.

3. 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.

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

5. (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.

6. In Connection args, enter the arguments to use to collect data.

7. 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 transformations 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.