Sending data between data models.
Hi Board,
We have two different data models and we need to sedn data from the one data model to the other and vice versa.
Currently what we have tried is the following:
- Extract the data from data model A, call a procedure in data model B that would import the extract through Azure using a data reader and paste the data into a cube.
- Use API queries and REST API aclls to pull data between the models.
- We looked at the pipeline but this would require us to use exstra connectors.
The problem with option one and two is that we have to create a file first.
Are there any other ways to send data between models without having to create an extract file for a data reader to pick up and push into a cube?
Kind Regards
Marius Lubbe
Accepted Answers
-
Hello Marius,
I hope you are doing well !
The idea I got that is not using a file is the procedure step "BULK Insert to SQL table" .
This step allows you to push your data to an SQL table. You can import it back from the sql on the other datamodel using data reader. It's not the most efficient but it allows you to go through a more secure option than flat files and you can keep the data available for your other model for future imports.
Let me know if this answer help.
I wish you a nice day !
Kind regards,
Yanis BOUAYAD
0 -
Hi @Marius Lubbe,
take a look at our best practice article about sinchronization between different data models.
It include different aspects such:
- Adding members to entities.
- Adjusting/managing changes in relationship(s).
- Feeding cubes.
0
Answers
-
Hi Yanis,
Thank you for the quick response.
Sadly our client's database is maintained by a third party company that cannot allow us to insert data back in the database using the bulk insert to SQL table.
Does this mean we only have the four options to send data between data models?
- Extract the data from data model A, call a procedure in data model B that would import the extract through Azure using a data reader and paste the data into a cube.
- Use API queries and REST API aclls to pull data between the models.
- We looked at the pipeline but this would require us to use exstra connectors.
- Use Bulk insert to SQL table and extract the data using the pipeline into the second datamodel.
Kind Regards Marius.
0 -
Thank you for the above information.
We will take it into consideration.Kind Regards
Marius Lubbe
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 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
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP