Introducing New Connectors in Access: Microsoft Dynamics and Salesforce

Published Aug 23 2017 08:58 AM 13.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

13 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-100015%22%20slang%3D%22en-US%22%3EIntroducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-100015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.office.com%2Fen-us%2F2016%2F11%2F04%2Fmicrosoft-access-now-included-in-office-365-business-and-business-premium-with-new-enhancements%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ELast%20November%3C%2FA%3E%2C%20we%20shared%20our%20plan%20to%20add%20a%20set%20of%20modern%20data%20connectors%20that%20will%20enable%20Office%20ProPlus%20customers%20to%20expand%20what%20is%20possible%20in%20their%20organizations.%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20pleased%20to%20announce%20the%20addition%20of%20two%20new%20connectors%20in%20our%20portfolio%3A%20%3CSTRONG%3EMicrosoft%20Dynamics%20and%20Salesforce%3C%2FSTRONG%3E.%20These%20two%20connectors%20are%20rolling%20out%20to%20customers%20with%20Office%20365%20ProPlus%2C%20E3%2C%20or%20E5%20plans.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F19065i2D66C96F6C5693A5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Blog1.png%22%20title%3D%22Blog1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAccess%20includes%20a%20%3CSTRONG%3Erich%20portfolio%20of%20external%20data%20connectors%3C%2FSTRONG%3E%2C%20among%20which%20you%20can%20find%20SQL%20Server%2C%20Azure%20SQL%2C%20Excel%2C%20SharePoint%2C%20Oracle%2C%20and%20more.%3C%2FP%3E%0A%3CP%3EThe%20new%20MS%20Dynamics%20and%20Salesforce%20data%20connectors%20in%20Access%20can%20be%20used%20in%20a%20variety%20of%20scenarios%2C%20supporting%20importing%20from%2C%20or%20linking%20to%20external%20data%20sources.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20567px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F19066i5C5E830F642AD97F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog2.png%22%20title%3D%22blog2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExtending%20the%20portfolio%20of%20external%20data%20connectors%20enables%20new%20scenarios%20for%20Access%20customers%20who%20wish%20to%20integrate%20line%20of%20business%20data%20from%20multiple%20data%20sources%20into%20one%20coherent%20solution%20in%20Access%2C%20and%20we%20will%20continue%20to%20release%20connectors%20to%20connect%20modern%20data%20sources%20to%20Access.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EKeep%20the%20ideas%20coming%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20you%20have%20other%20suggestions%20and%20ideas%20for%20the%20next%20version%20of%20Access%2C%20please%20%3CA%20href%3D%22https%3A%2F%2Faccess.uservoice.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%20Feedback%2C%20Provide%20Suggestions%20and%20Vote%20on%20the%20other%20suggestions%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-100015%22%20slang%3D%22en-US%22%3E%3CP%3EConnect%20to%20new%20modern%20data%20sources%20in%20Access%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-100015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353594%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353594%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20how%20to%20store%20the%20Salesforce%20username%20and%20password%20so%20they%20do%20not%20have%20to%20be%20entered%20each%20time%20you%20connect%20through%20Access%3F%26nbsp%3B%20I%20know%20this%20is%20possible%20for%20other%20Salesforce%20ODBC%20drivers%20by%20editing%20the%20registry%2C%20but%20I%20cannot%20find%20a%20way%20to%20do%20it%20for%20this%20Access%20Salesforce%20driver.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331049%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331049%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20the%20Dynamics%20365%20connector%20in%20Microsoft%20Access%20allow%20you%20to%20connect%20to%20CDS%20for%20Apps%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200224%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200224%22%20slang%3D%22en-US%22%3E%3CP%3EAccording%20to%20what%20I've%20read%20here%20and%20there%20Data%20Services%20%3D%20either%20generic%20access%20to%20web%20services%2C%20if%20you%20know%20how%20to%20configure%20that%2C%20or%20else%20a%20hook%20into%20sharepoint%20%22Business%20Connectivity%20Services%20Model%22.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198792%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198792%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20of%20the%20data%20sources%20offered%20is%20%22Data%20Services%22.%20That's%20about%20the%20most%20generic%20term%20anyone%20could%20have%20come%20up%20with.%20Does%20anyone%20know%20what%20it's%20about%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20what%20about%20the%20OData%20connector%20which%20was%20demoed%20by%20Michal%20in%202016%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20OData%20connector%20materializes%20will%20it%20mean%20there%20doesn't%20need%20to%20be%20a%20special%20connector%20for%20SQL%20Server%3F%20A%20non-odbc%20method%20of%20tapping%20sql%20should%20be%20the%20top%20priority%2C%20according%20to%20all%20of%20the%20Access%20devs%20I'm%20in%20touch%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188157%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46752%22%20target%3D%22_blank%22%3E%40Curt%20Wright%3C%2FA%3E%26nbsp%3BJust%20to%20answer%20you%20question%3A%20Yes%2C%20if%20you%20have%20the%20right%20security%20credentials%26nbsp%3B%20you%20can%20read%20AND%20write%20to%20tables%20in%20Dynamics%20365%20using%20the%20Data%20Connector%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172826%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F79254%22%20target%3D%22_blank%22%3E%40Sheryl%20Pass%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETagging%20onto%20what%20George%20said%20...%20so%20...%20%26gt%3B%3D%20Access%202016%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172155%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThese%20two%20connectors%20are%20rolling%20out%20to%20customers%20with%20%3CSTRONG%3EOffice%20365%20%3CEM%3EProPlus%2C%20E3%2C%20or%20E5%3C%2FEM%3E%20%3C%2FSTRONG%3Eplans.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-107925%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-107925%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20version%20of%20access%20to%20you%20need%20to%20have%20for%20these%20connectors%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-102585%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-102585%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20new%20Access%20Dynamics%20connector%20allows%20users%20to%20connect%20to%20Dynamics%20CRM%20(Customer%20Engagement)%2C%20and%20not%20Dynamics%20Financial.%3C%2FP%3E%0A%3CP%3EPlease%20use%20Access%20UserVoice%20site%20at%20%3CA%20href%3D%22https%3A%2F%2Faccess.uservoice.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccess.uservoice.com%3C%2FA%3E%20to%20make%20suggestions%2C%20ask%20for%20new%20features%20and%20vote%20on%20others'%20suggestions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-100814%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-100814%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20important%20to%20note%20that%20these%20new%20data%20connectors%20do%20NOT%20require%20installation%20of%20ODBC%20drivers%2C%20Access%20comes%20with%20the%20needed%20drivers%20built%20in%2C%20allowing%20you%20to%20deploy%20these%20solutions%20without%20them.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20encourage%20you%20to%20join%20us%20on%20Thursday%20September%2021st%20at%20the%20Spain%20AccessUserGroups.org%20meeting%20when%20Mauricio%20Orodnez%2C%20group%20program%20manager%20for%20Microsoft%20Access%2C%20will%20demo%20these%20new%20features%20in%20Spanish.%20For%20more%20info%20you%20can%20visit%20our%20page%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faccessusergroups.org%2Fespana%2Fevent%2Faccess-espana1-2017-09-21%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccessusergroups.org%2Fespana%2Fevent%2Faccess-espana1-2017-09-21%2F%3C%2FA%3E%20(details%20will%20be%20up%20soon).%20The%20meeting%20will%20be%20in%20Spanish%2C%20hope%20you%20can%20join%20us!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-100687%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-100687%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20this%20include%20reading%20and%20writing%20from%20Dynamics%20365%20Business%20financials%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-471600%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-471600%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20currently%20developing%20and%20testing%20a%20dotnet%20interop%20app%20that%20allows%20Access%20to%20integrate%20with%20QuickBooks%20Online%20via%20API%20calls%2C%20and%20was%20wondering%20if%20Microsoft%20would%20be%20interested%20creating%20a%20QBO%20connector%20for%20Access%2C%20Excel%20and%20Outlook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445046%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20New%20Connectors%20in%20Access%3A%20Microsoft%20Dynamics%20and%20Salesforce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46752%22%20target%3D%22_blank%22%3E%40Curt%20Wright%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20tested%20to%20connect%20to%20my%20Power%20Apps%20(Canvas%20%26amp%3B%20Model)%20database%20tables%2C%20which%20are%20sitting%20in%20CDS.%20Reading%20works%20fine.%20I%20can%20now%20make%20proper%20reports%20with%20Access%2C%20since%20reporting%20provided%20by%20Power%20Platform%20is%20not%20par%20with%20rest%20of%20the%20development%20environment%20(there%20is%20Reporting%20Wizard%20available%20%3CFONT%3Ewhen%20building%20a%20model-driven%20app%20with%20Power%20Apps).%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Aug 23 2017 08:58 AM
Updated by: