It is possible to export all or part of data from the current file/document/database to an external source: export to XML, transfer of reports to another system.
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;
Using this option will erase all existing accumulated data,
all resulting tables will be empty. |
- 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.
