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.
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.
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.