Extract Dynamics 365 Finance Operations to Azure SQL Database using BYOD (Bring Your Own Database)

Просмотров 5 тыс.

% 93

Today's video is one of the data extraction 101 series, showing you how to extract Dynamics 365 Finance and Operations data entity into Azure SQL Database, using a feature called BYOD (Bring Your Own Database).
Agenda:
0:00 Introduction
1:45 Demo
Further reading:
- BYOD by MS docs: docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/export-entities-to-your-own-database
- What is a data entity: docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities
- Enable change tracking: docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-change-track
Let's connect on:
- LinkedIn: www.linkedin.com/in/rizal-ang

Опубликовано:

14 июл 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@kaizen7729 3 года назад

Excellent explanation cleared my all doubts

@RizAngD 3 года назад

Glad it helped

@NitinKumar-td1wh 5 месяцев назад

Hi Riz, Just a question abt the public IP address you allowed. As far as I understand Dynamics 365 uses multiple IP addresses. Is there a way to track the IP addresses we need to allow in Azure so we can add the entire range ? I have have searched but have not found a concrete Microsoft doc. Also this exposes the database on the public internet. Does D365 support any other tech like private link, endpoint etc ? P.S: I work in the infrastructure space and currently doing this for our D365 team. Appreciate your advice. Thanks in advance

@sukumarmusalaboina3375 8 месяцев назад

Thanks for the video .. How to automate this process or doing it in ADF completely.

@UnbelievableOdyssey 7 месяцев назад

You'd need to use Data Flows. They support CDM natively.

@nagsworld Год назад

How can we automate this process?

@chakradharreddy6293 2 года назад

Dear Riz Ang, That is an amazing video. Could you please answer one question if you knew it. When D365 creates a table in BYOD does it create a primary key for that table?? The reason for asking this question is: We are building some small tool and our tool depends on the primary key of tables. As MS is pushing Data entity (which is like view data) I am assuming they don't have a primary key on that table. I also believe MS will never recommend creating table without a primary key. please answer by question.

@RizAngD 2 года назад

No problem Chakradhar, glad it's helpful! I'm afraid I don't know the answer either (funny that I never checked), we usually used BYOD tables as "staging" tables whereby these tables will be transformed into a different model (e.g. star schema) for reporting purposes. And for this reason, the primary key is not needed. I'd suggest (if you have access) you trial the export into BYOD and check in perhaps SSMS whether the key is created.

@chakradharreddy6293 2 года назад

@@RizAngD Thanks a lot Riz Ang for your kind reply. I understand you. I should definitely set up a system and check that. I am doubting MS might be keeping Auto ID as few databases like Postgres sql, Mysql has that. Anyhow let me check that. Appreciated your help.

@sheheryar89 Год назад

Thanks

@kalaiVani-nq2qe Год назад

Can you please explain on the Create recurring data job in Data Management

@meghakumari1506 7 месяцев назад

How can we bring D365fo tables like this?

@microsoft_boys 3 года назад

Hi @Riz, Can you please show mw how did you solve the previous errors? (05:2 Entity can not be publish and Object Reference not set) Thanks

@RizAngD 3 года назад

There's usually an issue with the way the tables (that make up the entity) are setup, I'd suggest you speak to the D365 developer and request their help. This is also what I did (since I'm not a D365 expert!)