ODBC drivers for Microsoft Access and Excel on Unix/Linux for SAS, SAP, Oracle, IBM

ODBC drivers for Microsoft Access and Excel on Unix/Linux for SAS, SAP, Oracle, IBM

January 02, 2013 0 Comments

From recent consulting projects, I have learned that analyzing data in Microsoft Office enables unique and valuable business insights across an organization.  In particular, these projects were based on ODBC connectivity to Excel/Access from applications such as SAS (SAS/Access interface to ODBC), Oracle Database Gateway for ODBC, SAP Data Services, IBM Cognos, Oracle Business Intelligence (OBIEE), and Tibco Spotfire.  This sort of competitive advantage reminds me of another megatrend, "Big Data".

Seriously, what does big data have to do with Microsoft Excel and Access?

Big data enables organizations to analyze data sets that were previously unavailable due to computing limitations.  With Microsoft Excel and Microsoft Access, the data is typically unavailable to many business intelligence (BI) initiatives since it cannot be easily accessed by Unix/Linux applications.   The commonality is that the analysis of both data sources have been overlooked for very different reasons; and I will share how you can gain additional competitive advantages by integrating Microsoft Office data using the DataDirect SequeLink ODBC drivers for Microsoft Access and Excel across AIX, Solaris, HP-UX and Linux.

Getting Started with Microsoft Access and Excel ODBC drivers for Unix/Linux

Watch this 13 minute video on installation and configuration using the trial download for the 64-bit SequeLink Client for ODBC to Microsoft Office on AIX:

Refer to the production documentation for complete details.

Who else is using DataDirect SequeLink?

  • Home Depot
  • Save the Children
  • The Winterthur Group
  • Northwestern Mutual
  • National Center for Genome Research (NCGR)
  • Mizuho Bank

Congratulations on becoming a Microsoft Office Data Scientist

Call us today at 1-800-876-3101 to speak live with a Solutions Consultant to learn more about integrating Microsoft Office data sources into your Unix/Linux platform.  Or you can download a free trial of the DataDirect SequeLink ODBC Socket today.

Sumit Sakar

Sumit Sarkar

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. 

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
ProgressNEXT: Premier Event for Modern Application Development
Read More
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More
Getting Started with Kinvey
Read More