Home Services Partners Company
Stress-free Connectivity for MS Access to Various Data Sources

Stress-free Connectivity for MS Access to Various Data Sources

September 12, 2013 0 Comments

Does it sound like a dream? We see a lot people coming to us at DataDirect looking for improvement of Microsoft Access connectivity. Because even with much more sophisticated tools available, Microsoft Access is still beloved by many as an internal Business Intelligence tool and information storage. Unfortunately, the native driver has its limitations, and with different versions the problems vary.

Sumit Sarkar has covered two areas where we can help in previous posts:

Link or Import Salesforce data to MS Access in real-time

MS Access connectivity to Oracle databases, especially when looking for 64bit driver

So when should you look at DataDirect drivers?

You need easy integration with SQL databases:

Every version of Microsoft Access has different issues with connectivity. The latest, MS Access 2013, is missing SQL Server Upsizing wizard. You can try your best looking around, or rely on our driver to do the job.

When upgrading between different versions of MS Access and Windows:

Again – due to various versioning, one set up that worked with MS Access 2007 may not work with MS Access 2010, though you may need to upgrade to MS Access 2010 as your company is moving towards Windows 7. It can become a Catch-22.

You need a more robust driver:

As the title states, we’re talking stress-free connectivity to various data sources. DataDirect ODBC drivers are very robust, even if you need to import items such as text files, for example. Simply check our connectivity matrix to be sure your data source is supported. Most likely you will need DataDirect Connect for ODBC 32bit (to connect to Oracle, SQL Server, DB2, Sybase and others) or DataDirect Connect XE for ODBC 32bit  (to connect to Salesforce and others), or if you have a newer version of MS Access in the 64bit mode, DataDirect Connect for ODBC 64bit or DataDirect Connect XE for ODBC 64bit.

You want your driver to support multiple database versions:

Knowing that setting up Microsoft Access correctly can be an issue, the DataDirect Technical support team has prepared plenty of “workarounds” available at our Knowledgebase. Simply look for “MS Access workarounds” or by error message.

You need better performance:

MS Access on Windows 7 can become very slow. Again, you can overcome the issue faced by native drivers with our ODBC driver. DataDirect drivers are industry standards for performance.

So what’s the bottom line? DataDirect ODBC drivers can really make your life much simpler, especially when you need to run and support multiple versions of MS Access.

What else can DataDirect do for MS Access data?

If you have MS Access databases and want integration of that data into your business intelligence and data warehousing infrastructure, we have solutions using DataDirect SequeLink to integrate Unix/Linux applications such as SAS, IBM Cognos, SAP Data Services, Business Objects, SSIS, or Ab Initio, to name a few. Or you can federate your data within Oracle using the database gateway for ODBC to MS Access or SQL Server Linked Server.

If you are interested how we could help you in your particular case, just try to download our free 15-day trial here.

Any questions? Contact us here or at Twitter @DataDirect_News. We are always happy to help you.

 

Zlata Palkovicova

View all posts from Zlata Palkovicova on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.

Read next SAS ODBC Access to Salesforce, SQL Server and Marketo
Comments
Comments are disabled in preview mode.