From consulting with several Oracle shops recently, I have learned that premium Progress DataDirect ODBC connectivity to Oracle databases from MS Access is equally as exciting as the mobile-bigdata-cloud mega trends to many of those organizations today. I remain impressed at the number of Microsoft Access power users running enterprises today, and this was further confirmed based on the interest in connecting Microsoft Access directly to Salesforce.com using ODBC. To understand why Oracle shops are flocking to DataDirect for MS Access ODBC connectivity, here are some reasons they shared:
In an ideal world, all of your database servers would be the latest/greatest version and no one ever has to fly third class on a domestic flight. For the real world, DataDirect drivers solve all of your application challenges supporting multiple database versions, and we will have Oracle 12 certified before you're ready to go live.
DataDirect wire protocol technology means no database client libraries need to be deployed to end users; and I've seen MS Access/ODBC deployments across 500+ workstations in an organization. It can be challenging to manage all those 32-bit and 64-bit $ORACLE_HOME locations when multiple versions of the database client are installed side by side. Newer versions of MS Access such as 2010 can be either 32-bit or 64-bit versions, and you are covered by DataDirect's impressive breadth of platform support.
DataDirect delivers superior performance over competing drivers. I consistently hear that performance varies depending on the combinations of database client (8i,9i,10g,11g) and server versions (8i,9i,10g,11g); however the single DataDirect ODBC Wire Protocol driver significantly outperforms the best non-DataDirect benchmark.
We get that a lot.
1. Download a trial of the DataDirect Connect for ODBC Wire Protocol drivers.
2. Set the following MS Access specific connection property per this knowledge article.
3. Launch MS Access 2010 (same steps apply for 2003 and previous versions)
4. Select “Blank Database” template and create access database
5. Click on External Data
6. Click “ODBC Database” Button
7. Next, select where you want to store the data in Access
You're now ready to experience DataDirect connectivity!
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. Call 1-800-876-3101 to speak with a live Solutions Consultant to learn more.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2018 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.