Blog Post

Access Blog
1 MIN READ

Introducing New Connectors in Access: Microsoft Dynamics and Salesforce

Michal_Bar's avatar
Michal_Bar
Icon for Microsoft rankMicrosoft
Aug 23, 2017

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.

 

 

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.

 

 

 

 

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

Updated Aug 23, 2017
Version 1.0
2016
access
developer
office 365
  • Juan Soto's avatar
    Juan Soto
    MVP
    Aug 25, 2017

    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!

  • Michal_Bar's avatar
    Michal_Bar
    Icon for Microsoft rankMicrosoft
    Aug 31, 2017

    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.

     

     

  • Curt Wright's avatar
    Curt Wright
    Copper Contributor
    Aug 25, 2017

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

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Mar 15, 2018

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

  • Michael Simcich's avatar
    Michael Simcich
    Copper Contributor
    Jun 02, 2018

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

  • Curt Wright's avatar
    Curt Wright
    Copper Contributor
    Feb 05, 2019

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

  • chennessy's avatar
    chennessy
    Copper Contributor
    Feb 19, 2019

    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.  

  • Tuomo Ruponen's avatar
    Tuomo Ruponen
    Copper Contributor
    Jun 06, 2020

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

  • Sheryl Pass's avatar
    Sheryl Pass
    Copper Contributor
    Sep 19, 2017

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