Home
Microsoft

Introducing New Connectors in Access: Microsoft Dynamics and Salesforce

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

9 Comments
Senior Member

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.

 

 

Frequent Visitor

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

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

Regular Visitor

@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

Occasional Visitor

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.

Occasional Visitor

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".