Copying Data from the Datastore

You can copy the measure or dimension data from the BI Gateway datastore to a pre-configured offline database in a local or remote server. Data copying is configured using the Microsoft SQL Server Management Studio. You must specify the server name and the database name to which you want to copy the measure or dimension data.

You can specify a data copy start and end date to manually copy the data. Alternatively, you can schedule a copy job and a data copy execution date. The copy job triggers a check to verify whether there was any data copy execution date during the given data copy period.

You can specify a start and end date and time, also called Absolute time. The data between the start and end date and time is copied to the pre-configured database.

Alternatively, you can schedule an event by specifying a duration in days to copy the data. You can also specify the offset days. For example, if you schedule a copy job of one month and specify the duration as 15 days, and the copy job identifies a data copy execution date as August 31, 2020, then the data for 15 days prior to August 31, 2020 is copied. If you specify a duration of five days, then the data for 15 days prior to five days before August 31, 2020 is copied. That is, data for 15 days prior to August 27, 2020 is copied.

The system copies the measure data along with the related dimension data for the specified date range.

The system merges the copied data with an existing data that was copied previously in the specified database. The data store database schema is retained in the specified database.

For more information on configuring the data copy job provided by the BI Gateway using SQL Server Management Studio, see the Microsoft SQL Server documentation.