Sending data between data models.

Marius Lubbe

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:

1. 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.
2. Use API queries and REST API aclls to pull data between the models.
3. 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

Yanis Bouayad

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