Transferring data directly from one database to another
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.
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 158 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP