USE CASES: UNIVERSAL ACCESS
With Progress DataDirect OpenAccess SDK, you can quickly build an ODBC, JDBC, OLE DB, or ADO.NET driver to make proprietary data SQL accessible from widely used reporting and analysis tools such as Crystal Reports and Microsoft Excel, and from development tools such as Visual Studio and Java.
OpenAccess SDK Use Cases
|
Access data contained in Progress applications (based on Progress Software’s database) from third-party reporting and analysis tools, such as Cognos, Business Objects, Brio, and Excel. |
|
|
As part of service-oriented architecture, make web services available to corporate desktop applications such as reporting and analysis tools. |
|
|
Easily create reports and analyze data from ERP systems with tools such as Crystal Reports, Brio, Excel, and others, while isolating those reports from changes in the underlying ERP system due to version upgrades, customization, or data relocation. |
|
|
Implement a DB2 federated system, which acts as an application server in which data can reside in various sources but be exposed as a virtual database for querying by client applications. |
|
|
Access ISAM files directly from standard desktop tools such as Microsoft Access, Microsoft Excel, Crystal Reports, and others. |
|
|
Access Java and .NET application data from standard desktop reporting, analysis, and database applications. |
|
|
Access information in SCADA systems from widely used desktop tools for reporting, analysis and application development. |
|
|
Add the ability to select and filter the large amount of information accessible from a web service. This enables the service to be leveraged better in future applications, a key requirement for a SOA. |
|
|
Provide access to data in BI, EII, EAI and analytics platforms from commercial tools such as Microsoft Access, Crystal Reports, Brio, and Excel and popular applications such as WebLogic, WebSphere and other Java-based platforms. |
|
|
Access data in financial applications from popular reporting and analysis tools such as Microsoft Access, Excel, Brio, Crystal Reports, and from EAI/EII platforms such as WebSphere and WebLogic. |
|
|
Access data in a commercial SQL database (Oracle, DB2 SQL Server, Sybase, etc.) from standard desktop tools such as Crystal Reports and Microsoft Access. |
|
|
Support access to relational and/or proprietary databases from standard desktop tools such as Microsoft Access and Crystal Reports. Use existing middleware (e.g., CORBA), which can execute SQL queries against one or more instances of the database. |
