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 Sarkar
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.