Import Data in CDS (Common Data Service)

By | February 14, 2019

Introduction

Common Data Service (CDS) for Apps lets you securely store and manage data that is used by business applications. Data within CDS for Apps is stored within a set of entities. Whether your data is stored in spreadsheets, databases, or other systems, you’ll probably want an easy way to transfer large data in your environment. Using import data feature in CDS, you can easily add data in CDS.

You can use two ways to import data in CDS.

1. Get data

2. Get Data from Excel

Common Data Service

This blog gives you information about how using Get data option, you can import data in CDS.

1. Get data:

Click on Get data and below window will open. It contains different type of data sources like Excel, CSV, XML, etc.

Common Data Service

2. Below is the example of importing data using Text/CSV data source. After selecting the Text/CSV below window gets opened:

3. Navigate through Browse > Upload > File > Select the file that you wish to upload.

Common Data Service

4. All uploaded files get listed as shown above. Select the file and click on Open.

Common Data Service

5. Select the organizational account in Authentication kind. Click on Next.

Edit Queries window will open where you can Add, Edit and Delete data from Excel sheet, as shown below.

Common Data Service

Double click on column name to edit the column name that helps you further. At a time you can import multiple Text/CSV, for that click on “Get data” and follow same process from the start and click on Next.

6. Map Entities page gets opened where you can select Load to existing entity option and select an entity, like here account entity is selected.

Then in Field Mapping section select the column of sheet by the name that you gave in excel sheet. Do the same for all fields and click on next.

Common Data Service

7. Select any Refresh settings and click on Create.

Common Data Service

8. Below window gets opened where LOAD STATUS will be shown. When LOAD STATUS gets completed then click on Done.

Common Data Service

Conclusion

Thus this blog shows how using Get data option, you can import data in CDS.

Generate Your Own New Leads Within Microsoft Dynamics 365 CRM

Contact us for a demo to know more about how Maplytics can help you to generate new leads from within Microsoft Dynamics 365 CRM.

Maplytics is a 5-star rated, preferred business app on the Microsoft AppSource that is Certified for Microsoft Dynamics 365 (CfMD) and comes with powerful features like Appointment Planning, Sales Routing, Territory Management, Heat Maps, Geo-analytical Dashboards and more that empower organizations to add more value to their CRM data, improve sales & service processes, and achieve high ROI.

Get your free trial from our Website or Microsoft AppSource!

‘If data is the new oil, location intelligence is ??”

6 thoughts on “Import Data in CDS (Common Data Service)

  1. Saurin

    Hello,

    Will it be okay, if I share the link of this blog in my own?

    1. Inogic

      Hi,

      Yes, you can share the link on your own blog. Kindly send us a link to your blog once posted.

      Thanks!

  2. Pooja

    Hi,

    Can we automate this task. to pick files one by one from one drive and do the import. We have lots of data. Please guide.

    1. Inogic

      Hi,

      There is no way to Automate the process of uploading the data from One Drive files one by one, but there is one workaround for this, you can create Power Automated Flow to do this. Make a connection with One Drive and attach triggers such as “When a file is created”, “When a file is modified” etc. After successfully created a connection, add the “Create a new record” step to create a Dynamics CRM record.

      I hope the above process helps you.
      Thanks!

  3. Alvaro Retana

    Thanks for the blog. Is there a way to import a table with the attachments of each item? I mean, I have a huge list in Quickbase, I need to migrate it to Microsoft dataverse, and each item has like 4 attachments. How can I import the whole relationship?

Comments are closed.