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".
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.
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.
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.
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
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.