Transferring data directly from one database to another

Niklas Multerer

Situation:

Assume that planning takes place in different databases for various reasons. Now the results of the planning are to be merged into one database. One possibility is to extract the data from the planning databases into a CSV and read it back into the reporting database.

Request:

It would be nice to have a function (e.g. Dataflow or Data Reader) with which you can copy the data from one cube of a database directly into another cube of another database, without CSV or other intermediate steps.

Reason and requirement

The CSV export and import method results in long loading times.

If the data is sensitive (e.g. HR), it may be stored as a CSV on the server, which is not desirable.

Databases can have different authorisations. Perhaps it would still be possible to enable retrieval with such a procedure step...

The multi-user functionality must also be considered.