DataStore Settings

This section explains on how to configure the Data store settings for storing extracted data from data sources.

DataStore is an intermediate database that is used to store imported data from web data sources and statistic files, there you will have a scheduled refresh option to update data.

Database configuration

We can connect to the existing SQL Server instance with the below actions

• Create new database for intermediate database.

• Use an existing database for intermediate database.
• Choose one of the database from Select a Database drop down for creating Data Store tables in that database.

NOTE

The credentials that is given to connect to the SQL Server instance must have permissions to

• Create Database
• Create Table
• Insert
• Update Table
• Alter Table
• Select
• Drop Table
• Drop Database