USE CASE: OPENING UP YOUR BI, EII, EAI, OR ANALYTICS PLATFORM

Goal

Provide access to data in BI, EII, EAI and analytics platforms from off-the-shelf commercial tools such as Microsoft Access, Crystal Reports, Brio, and Excel and popular applications such as WebLogic, WebSphere and other Java based platforms.

Issues and Alternatives

BI, EII, EAI and analytics platforms allow you to integrate data from various sources and perform processing on this data. They also provide custom presentation tools for implementing a GUI and running reports. However, many don't provide the connectivity required to get data into popular desktop tools. These tools require ODBC, OLE DB, or JDBC connectivity to bring data in without any custom programming.

Resolution

Use OpenAccess SDK to implement a custom ODBC, JDBC, OLE DB, or .NET driver for your platform. OpenAccess includes an enterprise quality SQL engine to efficiently execute complex queries.

Implementation

See Opening Up Your BI, EII, EAI, or Analytics Platform (.pdf)

Benefits

• Your customers can use commercial applications like Microsoft Access, Crystal Reports, Brio and any other ODBC, JDBC, OLE DB, or ADO.NET compliant application with your data source. 
• Quickly get a functional driver out to customers based on proven technology. 
• No code changes required to support additional data access standards as requirements evolve.