Data Export

Export to another database

Exporting data to another database.

Setting up connection with an external database

• ADOBasePass — user password for the external database;
• ADOBaseSett — settings of the external database used for data export;
• ADOBaseUser — username for the external database (requires CREATE TABLE, CREATE VIEW and other database-dependent operation rights).
  

Export parameters

• ADOTableCopyMode — using ADO table for data copying — this mode significantly slows down copying speed, used only in special cases;
• ConfigureParameters — Configure connection parameters in RKeeper 7 (external database settings, username and password for report server);
• CreateRKObjects — view for cubes, roles and logins for user;
• Description — Create table (DB Description) with descriptions of RKeeper 7 tables;
• ExportCHKdb — export accumulated data (check.udb), along with directory data (rk7.udb) necessary for cube aging and creation of RKeeper7 objects in the database;

• ExportLOGdb — export change log (log.udb), necessary if building a cube based on element change history is required;
• ExportRK7db — export directory data (rk7.udb), along with accumulated data (check.udb) necessary for building cubes and creating RKeeper7 objects in the database;
• StructureOnly — create only data structure, do not export any data.

The Test button — performs connection testing with the database.

Data export process to external SQL database

For export to an external database, it is necessary to select ADOBaseSett (Connection parameters).
After selecting connection parameters ADOBaseUser (Username) and ADOBasePass (Password) are filled automatically (data is taken from the Report Server directory property Connection with external database).

Before repeated export, it is necessary to uncheck the ExportCHKdb (Accumulated data) flag to avoid data clearing.
Through the Test button, perform connection testing with the database.
Click OK and wait for export to the external database with the result.

Directory of Data Export to Store House

Directory of Global Connect Export Settings

Export parameters

• GCAlternateNames — use alternative names (if specified);
• GCExportFileName — name of XML file with Global Connect data.

Directory of External Database Configuration

Contains a list of settings for connection with external database.

The directory contains the following properties:

• Main
• Other
• Basic
• Export Tools — contains information for establishing connection with the database.
• Restrictions

Directory of Store House Database Configuration

Setting up connection with Store House.

When clicking the Test button, connection testing with API and StoreHouse is performed.

Basic

• Password — Store House user password;
• Server — Store House server address;
• Username — Store House username;
• StoreHouse version — selection of StoreHouse and StoreHouse5 version.