Import Data in CDS (Common Data Service)

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

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.

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.

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

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.

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.

7. Select any Refresh settings and click on Create.

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

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 ??”