Migrate data from sql server to CDS

[memadAldien]

Is there a way to migrate data from sql server to CDS

[yashag2255]

Hey @memadAldien 

Yes, you can do that by following few steps:

1) Create the entity in PowerApps. Navigate to entity.
2) Select Get Data. This will open a pop-up window. Now, select SQL Server Database.
3) Provide data to create connection to SQL server, click Next.
4) Click Transform Data. Make sure that the column name are selected.
5) Click Next.
6) Select Entity in the dropdown and select Automap to map the fields. If this is not done automatically, you can manually assign fields.
7) Select Refersh Manually and click Next.
😎 Wait for the process to complete.
9) Once the process is complete, you should be able to see the data.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[memadAldien]

Thanks @yashag2255  for your reply, it's worked for me but I have an issue 

There is a field in entites called owner I use owner to set permissions and privalages 

in sql there is a field contains user_Id, I can map user_id to email but I can't migrate owner field

[yashag2255]

Hey @memadAldien 

This is not doable directly. I would recommend you to create another attribute and save this email value in it. Wherever you want to check for the user permission, you can use this newly created attribute. 

If you can share more details about this, maybe we can help you build an expression for checking the permission based on email id.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PAM-thrive]

I'm completely new to CDS, but this doesn't appear to be do-able if you are using a On-premise Data Gateway?

I am finding it a bit unbelievable and hoping I'm just wrong because PowerApps, Flow, PowerBI is all built around CDS from my understanding, seems silly if all these can talk to a data gateway but CDS itself cannot get data from one!

Did I miss something?