Introducing New Connectors in Access: Microsoft Dynamics and Salesforce
Published Aug 23 2017 08:58 AM 15.1K Views
Microsoft

Last November, we shared our plan to add a set of modern data connectors that will enable Office ProPlus customers to expand what is possible in their organizations.

Today, we are pleased to announce the addition of two new connectors in our portfolio: Microsoft Dynamics and Salesforce. These two connectors are rolling out to customers with Office 365 ProPlus, E3, or E5 plans.

 

Blog1.png

 

Access includes a rich portfolio of external data connectors, among which you can find SQL Server, Azure SQL, Excel, SharePoint, Oracle, and more.

The new MS Dynamics and Salesforce data connectors in Access can be used in a variety of scenarios, supporting importing from, or linking to external data sources.

 

 

blog2.png

 

 

Extending the portfolio of external data connectors enables new scenarios for Access customers who wish to integrate line of business data from multiple data sources into one coherent solution in Access, and we will continue to release connectors to connect modern data sources to Access.

 

Keep the ideas coming
If you have other suggestions and ideas for the next version of Access, please Add Feedback, Provide Suggestions and Vote on the other suggestions

14 Comments
Copper Contributor

Does this include reading and writing from Dynamics 365 Business financials?

It's important to note that these new data connectors do NOT require installation of ODBC drivers, Access comes with the needed drivers built in, allowing you to deploy these solutions without them. 

 

I encourage you to join us on Thursday September 21st at the Spain AccessUserGroups.org meeting when Mauricio Orodnez, group program manager for Microsoft Access, will demo these new features in Spanish. For more info you can visit our page at https://accessusergroups.org/espana/event/access-espana1-2017-09-21/ (details will be up soon). The meeting will be in Spanish, hope you can join us!

Microsoft

The new Access Dynamics connector allows users to connect to Dynamics CRM (Customer Engagement), and not Dynamics Financial.

Please use Access UserVoice site at https://access.uservoice.com to make suggestions, ask for new features and vote on others' suggestions.

 

 

Copper Contributor

What version of access to you need to have for these connectors? 

Silver Contributor

These two connectors are rolling out to customers with Office 365 ProPlus, E3, or E5 plans.

Copper Contributor

@Sheryl Pass  

Tagging onto what George said ... so ... >= Access 2016

@Curt Wright Just to answer you question: Yes, if you have the right security credentials  you can read AND write to tables in Dynamics 365 using the Data Connector

Copper Contributor

One of the data sources offered is "Data Services". That's about the most generic term anyone could have come up with. Does anyone know what it's about?

 

Also what about the OData connector which was demoed by Michal in 2016?

 

If the OData connector materializes will it mean there doesn't need to be a special connector for SQL Server? A non-odbc method of tapping sql should be the top priority, according to all of the Access devs I'm in touch with.

Copper Contributor

According to what I've read here and there Data Services = either generic access to web services, if you know how to configure that, or else a hook into sharepoint "Business Connectivity Services Model". 

Copper Contributor

Does the Dynamics 365 connector in Microsoft Access allow you to connect to CDS for Apps data?

Copper Contributor

Does anyone know how to store the Salesforce username and password so they do not have to be entered each time you connect through Access?  I know this is possible for other Salesforce ODBC drivers by editing the registry, but I cannot find a way to do it for this Access Salesforce driver.  

Copper Contributor

We are currently developing and testing a dotnet interop app that allows Access to integrate with QuickBooks Online via API calls, and was wondering if Microsoft would be interested creating a QBO connector for Access, Excel and Outlook.

Copper Contributor

@Curt Wright 

I just tested to connect to my Power Apps (Canvas & Model) database tables, which are sitting in CDS. Reading works fine. I can now make proper reports with Access, since reporting provided by Power Platform is not par with rest of the development environment (there is Reporting Wizard available when building a model-driven app with Power Apps).

Iron Contributor

great and awesome info 

Version history
Last update:
‎Aug 23 2017 08:58 AM
Updated by: