[Progress Communities] [Progress OpenEdge ABL] Forum Post: 2020.1 Progress DataDirect for JDBC for Aha! driver: Initial Preview Release

Status
Not open for further replies.
T

Thomas Dixon

Guest
Feature Description: The Progress DataDirect for JDBC for Aha! driver supports SQL read-only access for JDBC applications to the Aha! roadmap application. To support SQL access to Aha services, the driver creates a relational map of the Aha data model and translates SQL statements to Aha REST API requests. In addition, the driver employs a SQL engine component that provides support to SQL constructs unavailable to Aha services. This functionality offers a number of advantages, including support for reporting data and metadata in a form that JDBC applications are ready to use. Minimum Requirements: The driver is compatible with JDBC 2.0, 3.0, 4.0, 4.1, and 4.2. The driver requires a Java Virtual Machine (JVM) that is Java SE 8 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions. Authentication The Aha driver supports the following authentication methods: Basic Authentication URLParameter Authentication using an Aha API Key OAuth 2.0 Authentication Connection information required to establish a connection to Aha! services using Basic Authentication: Server Name Username Password Connection information required to establish a connection to Aha! services using URLParameter Authentication: Server Name Security Token (your Aha! API Key) Connection information required to establish a connection to Aha! services using OAuth: Server Name Redirect URI Client ID Client Secret Authorization Code You must register an application with Aha! in order to obtain the required connection information. See the Aha! documentation for specific information on this process: OAuth2 Authentication for API Access | Aha! Configuration Manager The driver includes a browser-based tool, Progress DataDirect Aha! Configuration Manager, that allows you to generate connection URLs, test connections, and execute test queries. To open the Configuration Manager, double-click the driver jar file; or, execute the following command at a command prompt in the directory containing your driver jar file: java -jar aha.jar From the browser window, provide values of the connection properties you want to configure in the corresponding fields. A connection URL will generate in the Connection String field as you provide settings. Documentation for the various connection properties will be displayed in the right pane of the Configuration Manager when clicking on any property, or its text entry box. Installation Guides: Windows: Progress® DataDirect® Linux: Progress® DataDirect® Installation Notes: The preview installation will expire in 15 days after it is installed. No control numbers are required. For Serial Number you can enter in a numeric value, such as 123. Use Case: JDBC compliant applications needing connectivity to Aha! to perform read-only queries. BI tools for data analysis. ETL tools performing operations (reading) data from Aha!. Requested Feedback: Are you able to use the driver out of the box? If not, please provide details about the challenges you faced/are facing. What are your primary use cases, and is this driver solving them? Is the driver's performance acceptable for your primary use case? If not, please provide details on your use case, operation being performed, data size, and expectation. Download Information: User's Guide: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=3VEEF7DMOD06F Windows Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=3SVMKVIP1JKMR All-platforms Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=2ZPW0KQ93A14B

Continue reading...
 
Status
Not open for further replies.
Top