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.
We can connect to the existing SQL Server instance with the below options
New Database
option. Save
button.Existing Database
option. Select a Database
drop down for creating Data Store tables in that database and click the Save
button.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