Progress Jdbc Driver

1 standards, and compatible with ANSI SQL-92. As far as I know there are only two companies in the world that produce ODBC/JDBB connectivity drivers for Progress DB: OpenLink and DataDirect (now acquired by Progress). Add support for HTTP / KNOX support in the Progress JDBC Hive Driver United States Datadirect JDBC v6. The question is simple, I need to know if what I'm doing has any sense. I know there is a driver called com. 0 or higher. The drivers are compliant with Type 4 architecture, but provide advanced features that define them as Type 5 drivers. 1E using SqlExplorer tool. You can also select the driver and then click List Drivers to retrieve a list of available names. The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. To support SQL access to Cassandra, the driver creates a relational map of native Cassandra data and translates SQL statements to C. OpenEdgeDriver datadirect:openedge Restart Jitterbit service by running StartServices. * pdf FusionReactor JDBC Driver Wrapper: User Guide This problem does not occur with the MS SQL Server 2005 JDBC Driver. I put these files in a directory of BIRT. If you see something that is not correct, know of a driver that is not listed here, or have a tip you want to share, please let us know by using the comments fields found at the bottom of this article. The minimum Progress license that includes the ODBC driver is the Progress SQL Client Access Product. The following sections describe the steps for installing a JDBC Driver, and also how to configure DbVisualizer to use JNDI to obtain a database connection. 0 Driver for SQL Server! This new driver now supports Always Encrypted, Internationalized Domain Names, Parameterized Queries, and is fully compliant with JDBC specifications 4. Note the change: from "microsoft. The Java Database. 1d odbc exists some % free OBDC driver. The connection URL typically points to one of the locators. 10 32-BIT Progress SQL92; Jasper Studio version : TIBCO Jaspersoft Studio-6. HIVE-10447 enabled the JDBC driver to support 2-way SSL in HTTP mode. This is an informational message and it highlights the runtime progress of the shared resource. OS : Linux. jar (on your class path). Readbag users suggest that Progress JDBC Driver Guide is worth reading. The minimum build level. This quick start guide provides the basic information necessary to install, configure, and connect to Jira data sources. Audience This book is designed as a. The Bridge is itself a driver based on JDBC technology ("JDBC driver") that is defined in the class sun. My database and driver details are as below: Database Product Version 9. Java version "1. 1 ProgressDataDirectConnectSeriesforJDBC InstallationGuide ThisguideprovidesinformationoninstallingProgress® DataDirectConnect® SeriesforJDBC ™,whichincludesthe. CocoBase sits of top of JDBC to make it more programmer-friendly. Just one of the problems that arises from Progress not being a native SQL db :-). jar file path is found either in the "Classpath" text box, or in the. Important: After Tableau 10. See Progress Version 9 product availability matrix, look for ODBC and JDBC. Installing Progress DataDirect SQL Server JDBC Driver By the end of this section, you would have installed the Progress DataDirect SQL Server JDBC driver. Add support for HTTP / KNOX support in the Progress JDBC Hive Driver United States Datadirect JDBC v6. Suppose you have a light weight version of SQL Server installed, such as Microsoft SQL Server 2012 Express. Accessing Data Using JDBC on AWS Glue java -jar PROGRESS_DATADIRECT_JDBC_SF_ALL. pdf file and it says to check the classpath, url and driver commands and they all seem correct so I'm at a bit of a loss. The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) type 4 driver that implements full compliance with the JDBC specifications 4. Where can I find the latest version of the JDBC driver for Progress 9?. log for each established connection These files contain information on the called driver methods and the progress of the JDBC connection. The minimum build level. [xyzcompany][SQLServer JDBC Driver] Object has been closed ee java -jar PROGRESS_DATADIRECT_CONNECT_JDBC_5. SQLServerDriver". It can assist the Exasol Support in the diagnosis of problems. I try to copy progress JDBC driver jar files from the progress database installation directory into my windows machine and try to run it, it fails to run. Note that this entry is available if a valid. Configuring Progress DataDirect Cloud as the data source in a JDBC application test and configure the JDBC cloud driver so you'll be able to access your data sources with any JDBC-compliant. Googling seems to reveal among others a promisingly titled page "Progress JDBC Driver Guide". (bin contains the. DataDirect JDBC drivers are compliant with the Type 4 architecture, but provide advanced features that define them as Type 5 drivers. BEDFORD, Mass. The Progress DataDirect Type 5 JDBC SQL Server driver delivers the best performance and scalability for Java applications connecting to Microsoft SQL Server. JDBC Driver Logging. Hi Bibi, We support Kerberos in the SQL Server JDBC driver, but not in the Impala JDBC driver. Note: The latest JDBC driver, corresponding to Hive 0. CocoBase sits of top of JDBC to make it more programmer-friendly. jar to connect to each AF and PI. x is in progress. We leveraged the progress. jdbc" In addition, the SQL Server 2005 JDBC driver has a different URL prefix from the SQL Server 2000 JDBC driver. It was an available option in the dropdown list when creating a new universe connection. OpenEdgeDriver driver. Your options are the rather expensive IDS Server or rmiJDBC. 4P2 Driver; Oracle 8i, 9i and 10g with the Oracle thin and OCI drivers. Analytic tools may use 3rd party drivers from providers such as Data Direct. jar,progress_messages. The Teradata JDBC Driver Engineering team receives a lot of questions about what happens when a JDBC connection is created. I have been charged with creating an application that will access this data. NET and OLE DB that provide transparent access to enterprise databases. If you want a client side install you can go into your ESD account and download the "Progress SQL client access ODBC/JDBC drivers" product. Charlie Arehart - Server Troubleshooting - New DataDirect JDBC Type 5 drivers (for SQL Server, MySQL, Oracle, and more) Progress DataDirect # Posted By Mike Frost. For MySQL, database driver can be com. Follow the instructions for Installing Cloudera JDBC and ODBC Drivers on Clients in CDH. What is the URL and ClassName for the JDBC driver in OpenEdge 10. com using beta versions of the JDBC drivers that are available today from Progress Software, with a new. TIBCO-BW-SR-JDBC-400001. com/javase/1. Developers can access Salesforce, and applications built on Force. NET data providers, and OLE DB providers. DataDirect Connect for JDBC provides the benefits of Type 5 features across all versions of Postgresql. For example using Windows with the progress client installed wither 9. The connection URL typically points to one of the locators. jar in classpath and C:\Program Files\Progress\bin in path. Connecting to Autonomous Data Warehouse with Progress DataDirect ODBC Driver December 11, 2018 1 Autonomous Data Warehouse (ADW) supports connections from standard drivers including JDBC, ODBC, and ADO. JDBC is a Java based API that uses SQL queries and provides Java classes that abstract data access. We run our core business logic in Progress and want to use jasper as the presentation layer. To enable logging in JDBC drivers, you need to append the proper key/value pairs to your connection string or connection URL. If you also need a progress runtime on the client side you can purchase the "Client Network" license that will also include the ODBC/JDBC drivers. The Progress ® DataDirect ® for JDBC ™ for Jira ™ Driver (Jira driver) supports SQL read-only access for JDBC applications to Atlassian Jira. 1b)using the jdbc drivers. This section describes how to set up your installation to use a driver other than the default driver. On "Database Location" tab I put this. Where can I find the latest version of the JDBC driver for Progress 9?. This is an informational message and it highlights the runtime progress of the shared resource. sforce-jdbc. jar file paths and. The ODBC driver is also packaged with Progress Client Products listed in Article: 000020494, What Progress licenses install the ODBC SQL-92 and JDBC drivers The SQL Client Access product includes the JDBC and ODBC Driver. The minimum Progress license that includes the ODBC driver is the Progress SQL Client Access Product. Database drivers are continually being added to each operating environment. What is the URL and ClassName for the JDBC driver in OpenEdge 10. Licensee ID. The Progress DataDirect Type 5 JDBC driver delivers the best performance and scalability for Java applications connecting to Postgresql. sbo file and mapped the appropriate Progress jdbc drivers saved to our BOE app server. If you also need a progress runtime on the client side you can purchase the "Client Network" license that will also include the ODBC/JDBC drivers. Driver Preferences. It is only in rare instances where you would need to purchase an ODBC or JDBC driver directly from DataDirect. Choose Parasoft> Preferences to open the Preferences panel. - The Teradata JDBC Driver now provides login timeout functionality using the value set with DriverManager setLoginTimeout or DataSource setLoginTimeout. JdbcOdbcDriver. What JDBC driver should I use? 2. CocoBase sits of top of JDBC to make it more programmer-friendly. It gives the following error. The following table shows the JDBC adapters included with Denodo Scheduler. Does anyone know what connection architecture should I use to run under such environment? Thanks. For Tableau Bridge, use the same drivers as Tableau Desktop. I believe user124 supplied you with the remedy. Enhanced DataDirect ® Drivers Offer Greater Resource Efficiency. Please tell us how we can make this article more useful. Where to Find JDBC Drivers. 0 drivers are a reasonably priced option. Get the JDBC driver file(s) DbVisualizer comes bundled with all commonly used JDBC drivers that have licenses that allow for distribution with a third party product. First you'll need a driver installed. Since upgrading to 4. Where can I find the latest version of the JDBC driver for Progress 9?. 10 32-BIT Progress SQL92; Jasper Studio version : TIBCO Jaspersoft Studio-6. The ODBC and JDBC drivers are shipped with the OpenEdge database. The Progress ® DataDirect ® for JDBC ™ for Apache Hive ™ driver supports SQL and HQL query languages for read-write access to distributions of Apache Hive, versions 1. Additionally, the drivers consistently support the latest database features and are fully compliant with Java™ SE 8 and JDBC 4. Access denied and Authorization failed mean that you either have the wrong userid & password or you are attempting to connect to the wrong db. com/javase/1. dll files) 2) I am trying to connect to the Progress Database9. I did not install database and I can not access to %DLC%\java. com or the new Database. Find the driver for your database so that you can connect Tableau to your data. The new JDBC driver is designed "to enable Java applications to fully take advantage of the past decade's worth of database improvements and enhancements," the company said. jar" files which are in the dlc\java directory. OpenLink Universal Data Access Drivers - High-performance data access drivers for ODBC, JDBC, ADO. OpenEdge JDBC driver loader. For the other drivers, you'll need to add the driver jar files first. But still i am not able to get the connection with the database. Googling seems to reveal among others a promisingly titled page "Progress JDBC Driver Guide". 1? I use java and JDBC if it is important. For Tableau Bridge, use the same drivers as Tableau Desktop. How to identify JDBC driver version for OpenEdge? Your feedback is appreciated. Feb 03, 2016 · I know this is an old question, but it isn't answered yet. Note that this entry is available if a valid. Error: [DataDirect][OpenEdge JDBC Driver]SSL Mismatch. WebLogic-branded DataDirect drivers are installed by default when you perform a complete installation of WebLogic Server. This section describes how to set up your installation to use a driver other than the default driver. The ODBC driver is also packaged with Progress Client Products listed in Article: 000020494, What Progress licenses install the ODBC SQL-92 and JDBC drivers The SQL Client Access product includes the JDBC and ODBC Driver. sbo file and mapped the appropriate Progress jdbc drivers saved to our BOE app server. This video will also show you how you can obtain the Spark SQL. My ODBC-connections to the same resources work fine, but Talend requires a JDBC connection to function properly. For the latest information about the specific drivers available for your platform, refer to the readme file in your software package or refer to the Progress DataDirect database support matrix Web pages at:. DataDirect JDBC Drivers - cost of training: Relevant for DataDirect JDBC Drivers As a software buyer, you are required to pay extra for in-person training, though some vendors offer web-based training as part of the package. Welcome to the Progress DataDirect for JDBC for Oracle Driver. In the driver preferences, you can see which drivers are currently available. The JDBC driver has logging capability to capture the communication between the application client and the driver (Spy) and the communication between the driver and the database server (Packet logging or Snoop). Excerpted from Progress KB In one instance, the issue occurred when using two different copies of the JDBC driver. See the complete profile on LinkedIn and discover Jeff’s connections. Get the JDBC driver file(s) DbVisualizer comes bundled with all commonly used JDBC drivers that have licenses that allow for distribution with a third party product. For MySQL, database driver can be com. See Progress Version 9 product availability matrix, look for ODBC and JDBC. Select Available JDBC Drivers on the left. Know More By Logging In. Please note that the validity of the links listed below cannot be guaranteed. If the value exceeds a restriction, the driver truncates it. 0 or higher, consider upgrading to the latest Hive JDBC driver for best performance with JDBC applications. If the driver is not configured correctly, you must edit its configuration. jar,progress_messages. Welcome to the Progress DataDirect for JDBC for Oracle Driver. If you want a client side install you can go into your ESD account and download the "Progress SQL client access ODBC/JDBC drivers" product. Charlie Arehart - Server Troubleshooting - New DataDirect JDBC Type 5 drivers (for SQL Server, MySQL, Oracle, and more) Progress DataDirect # Posted By Mike Frost. Additionally, the drivers consistently support the latest database features and are fully compliant with Java™ SE 8 and JDBC 4. sbo file and mapped the appropriate Progress jdbc drivers saved to our BOE app server. If you have access to the server that the db runs on you can test your credentials using Progress' sqlexp command line tool:. jar and jdbc. 0 drivers are a reasonably priced option. 1E using SqlExplorer tool. Where to Find JDBC Drivers. I even copied the connect string to SQL explorer and it connects so I know thats right(sql explorer seems to use the jdbc to odbc bridge though). 1D to OE 10. --(BUSINESS WIRE)-- Progress Software Corporation (NASDAQ: PRGS), a leading software provider that enables enterprises to be operationally responsive, made available the latest version of its JDBC drivers, Progress ® DataDirect Connect ® for JDBC 5. Even so, you won't find any free type 3 or 4 drivers for it. 0 functionality. 2 This guide documents installing the 5. In order to connect to an external database, both Corticon Studio and Server need access to a JDBC driver for the specific database product being used. DataDirect Connect for JDBC provides the benefits of Type 5 features across all versions of Postgresql. The value is specified as a semicolon separated list of fully-qualified directory paths,. The SQL Connector defines schemas on the fly providing a low touch SQL window to MongoDB data. Try DataDirect Drivers Now. Seems to work with Informix Dynamic Server Version 7. 4 JDBC Thin driver (ojdbc6. The Salesforce Driver has the same JDBC architecture as the JDBC drivers for MySQL and OLEDB, including Connection, Statement and ResultSet objects. Driver Version 1. Suppose you have a light weight version of SQL Server installed, such as Microsoft SQL Server 2012 Express. NET data providers, and OLE DB providers. user10546563 wrote: I undestand that it is the normal problem in the progress database. x is in progress. UD3, Informix JDBC driver version 2. There are several additional enhancements available with the driver. These parameters are used to identify the type of database and create a connection to use the database. Follow the instructions for Installing Cloudera JDBC and ODBC Drivers on Clients in CDH. The steps below will guide you through installation and configuration of our Lite Edition (Single-Tier) ODBC-JDBC Bridge Drivers for Windows. The SQL Server 2005 JDBC driver class name is "com. DataDirect JDBC drivers are compliant with the Type 4 architecture, but provide advanced features that define them as Type 5 drivers. com using beta versions of the JDBC drivers that are available today from Progress Software, with a new. What license do I need on client side in order to connect Progress database from Java? What minimum client license contains SQL-92 JDBC driver? What Progress products contain the SQL-92 ODBC driver? What Progress products contain the SQL-92 ODBC and JDBC drivers? What products are required on the client side to setup a JDBC connection?. jTDS is an open source 100% pure Java (type 4) JDBC 3. Find the driver for your database so that you can connect Tableau to your data. pdf file and it says to check the classpath, url and driver commands and they all seem correct so I'm at a bit of a loss. It gives the following error. Whether your data source is a proprietary. You can read more about their solution in this overview document to understand more about why you need such a bridge. OpenLink Universal Data Access Drivers - High-performance data access drivers for ODBC, JDBC, ADO. x and drivers 1. To help you evaluate this, we've compared DataDirect JDBC Drivers Vs. The Progress ® DataDirect Connect ® Series for JDBC ™ provides a suite of JDBC drivers that supports most leading databases. If the server-side internal driver is executing a SQL statement, then no Java thread can call the Statement. Progress DataDirect OpenAccess REST IP code for Alpha Vantage API for accessing the data using ODBC and JDBC drivers. Analytic tools may use 3rd party drivers from providers such as Data Direct. OpenEdge JDBC driver loader. Note Due to Oracle license restrictions, the Oracle JDBC driver is not available in the public Maven repository. The access to the Hive data source is provided through the Progress Datadirect JDBC Driver for Hive. The Bridge is itself a driver based on JDBC technology ("JDBC driver") that is defined in the class sun. If you see something that is not correct, know of a driver that is not listed here, or have a tip you want to share, please let us know by using the comments fields found at the bottom of this article. Go into Window->Services. Programmers usually use such a bridge when they lack an ODBC driver for some database but have access to a JDBC driver. OPENEDGE JDBC DRIVER - Learn about for your business. 0 JDBC driver is now certified with OpenJDK11. log for each established connection These files contain information on the called driver methods and the progress of the JDBC connection. Trusted by Fortune 500 Companies for cutting edge software products for - Universal Database Querying, Private Cloud Backup, Encrypted File Sharing and Email Security. Anyway I've looked at the progress supplied jdbc. The driver must be available on your CLASSPATH. This quick start guide provides the basic information necessary to install, configure, and connect to Jira data sources. Error: [DataDirect][OpenEdge JDBC Driver]SSL Mismatch. The next version will be. This driver translates ODBC function-calls into JDBC method-calls. The Progress ® DataDirect ® for JDBC ™ for Salesforce ™ driver supports standard SQL query language to select, insert, update, and delete data from Salesforce. The JDBC driver has logging capability to capture the communication between the application client and the driver (Spy) and the communication between the driver and the database server (Packet logging or Snoop). Driver Preferences. 5, we are changing the way we number new versions of our software. This reference is a continuous work in progress. If you have access to the server that the db runs on you can test your credentials using Progress' sqlexp command line tool:. TIBCO-BW-SR-JDBC-400001. 1 we noticed that option is no longer present. It can assist the Exasol Support in the diagnosis of problems. JDBC Driver Logging. I am trying to connect to Progress Database from ColdFusion v7 sot hat I can run a query against the table in the Progressive database. [Progress Communities] [Progress OpenEdge ABL] Does the Mongo JDBC Driver support connecting to the active listener ? Thread starter smudigonda Start date Today at 5:32 AM. Where can I download the JDBC driver for Progress OpenEdge 10. They had to. Hi all I am working with a progress database and JDBC. This is an informational message and it highlights the runtime progress of the shared resource. Let's get started with it. Progress DataDirect. Behind the scenes progress is looking for DLL's. Download trial version of JDBC Progress® OpenEdge® Connector for Windows and test a unique data connectivity solution used by enterprises worldwide. See Progress Version 9 product availability matrix, look for ODBC and JDBC. 0 or higher. pdf file and it says to check the classpath, url and driver commands and they all seem correct so I'm at a bit of a loss. The access to the Hive data source is provided through the Progress Datadirect JDBC Driver for Hive. sbo file is no longer present either. To get the JAR files, install the Hive JDBC driver on each host in the cluster that will run JDBC applications. BEDFORD, MA, Apr 27, 2010 (MARKETWIRE via COMTEX News Network) -- Progress Software Corporation (NASDAQ: PRGS), a leading independent enterprise software provider that enables companies to be operationally responsive, today announced the launch of Progress(R) DataDirect(R) Connect for JDBC(TM), the industry's first Type 5 JDBC drivers. Type in the driver class name in manually. DataDirect provides a branded driver for the Progress database. The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. JDBC Driver: com. 0? Products Mobility and High Productivity App Dev Cognitive Services Data Connectivity and Integration UI/UX Tools Web Content Management OpenEdge. SQL support includes functions, expressions, aggregation, and joins including for collections with nested objects and arrays. 2 This guide documents installing the 5. Analytic tools may use 3rd party drivers from providers such as Data Direct. Encryption method in client and server must match. jar (on your class path). Downloads are available in source and binary formats at the PostgreSQL downloads site. The Progress® DataDirect Connect® drivers are unique in the market as they are the only drivers that use SQL to enable. Progress DataDirect’s JDBC Driver for Oracle offers a high-performing, secure and reliable connectivity solution for JDBC applications to access Oracle data. Does Snoop logs gets generated with DataDirect Google BigQuery JDBC Driver 6. Common JDBC Drivers. The Progress ® DataDirect Connect ® Series for JDBC ™ provides a suite of JDBC drivers that supports most leading databases. sbo file is no longer present either. 0 drivers are a reasonably priced option. bat in your Jitterbit Home directory; Go to Jitterbit Studio and create a new data source: Pick Progress OpenEdge [JDBC] Enter your credentials. Importing Salesforce Data Into Amazon s3 via Jdbc Driver This article provides a tutorial on importing data from Salesforce into AWS S3 using AWS Data Pipeline and Progress JDBC driver. 1A and later? How do I setup an OpenEdge 10. What are the steps to configure JDBC driver on OpenEdge 10. jar and ojdbc5. You need jdbc. Assuming that is the case: First you need a JDBC driver for Progress. In order to connect to an external database, both Corticon Studio and Server need access to a JDBC driver for the specific database product being used. SQL support includes functions, expressions, aggregation, and joins including for collections with nested objects and arrays. Contribute to abevoelker/jdbc-openedge development by creating an account on GitHub. For later versions there is an 'OpenEdge driver'. The following table shows the JDBC adapters included with Denodo Scheduler. See Progress Version 9 product availability matrix, look for ODBC and JDBC. Welcome to the Progress DataDirect for JDBC for Oracle Driver. Licensee ID. The main purpose of the driver is to retrieve (only) data from Salesforce services for data analysis. What JDBC driver should I use? 2. Join now to stay up-to-date on Connect product updates. jar,progress_messages. I have almost everything working except for one small issue. We leveraged the progress. For example, the following JDBC URL connects to your cluster using Secure Socket Layer (SSL), user (UID), and password (PWD). In order to work with ADW, the driver must support Oracle. A JDBC driver is a software component enabling a Java application to interact with a database. The Progress ® DataDirect ® for JDBC ™ for Apache Cassandra ™ driver supports SQL read-write access to DataStax Enterprise 4. 0 and higher. Database URL:. The Teradata JDBC Driver reads only one response message at a time from the Teradata Database, as the application fetches through the result set. This post dives into using the Progress JDBC driver(s) to connect to various databases using Java and standard JDBC programming. The new JDBC driver is designed "to enable Java applications to fully take advantage of the past decade's worth of database improvements and enhancements," the company said. Download trial version of JDBC Progress® OpenEdge® Connector for Windows and test a unique data connectivity solution used by enterprises worldwide. jar and jdbc. For more details on the driver configuration parameters, refer Progress DataDirect JDBC Driver for Hive. sbo file and mapped the appropriate Progress jdbc drivers saved to our BOE app server. Go into Window->Services. The minimum build level. If the value exceeds a restriction, the driver truncates it. To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database. I know this is an old question, but it isn't answered yet. To find version information about these built-in drivers, click here. We leveraged the progress. It describes how to set up and use the driver and details the driver's support for the JDBC interface. In DbVisualizer these non supported databases are handled as generic databases. Magical JDBC drivers from Progress DataDirect meet all of these challenges to supercharge your Sqoop usage within the Hadoop ecosystem. jar and jdbc. I put these files in a directory of BIRT. The SQL Connector defines schemas on the fly providing a low touch SQL window to MongoDB data. [xyzcompany][SQLServer JDBC Driver] Object has been closed ee java -jar PROGRESS_DATADIRECT_CONNECT_JDBC_5. com SOLUTION BRIEF USING DATADIRECT OPENACCESS FOR CLOUD-BASED APPLICATIONS OPENACCESS SDK: THE INDUSTRY'S LEADING CUSTOM DRIVER DEVELOPMENT KIT The Progress DataDirect OpenAccess Software Development Kit (SDK) enables custom drivers for any data source to be developed within weeks. Work with your DBA or visit the Azure portal to ensure Firewall settings are configured properly between Azure and the Information Server installation as well as acquiring the SERVER, PORT, DATABASE_NAME, USER, PASSWORD, etc values. 0 or higher, consider upgrading to the latest Hive JDBC driver for best performance with JDBC applications. It describes how to set up and use the driver and details the driver's support for the JDBC interface. The main purpose of the driver is to retrieve (only) data from Salesforce services for data analysis. In the "Driver" box, select com. Download Driver Jar from Vendor Website. For earlier versions, refer to the Progress DataDirect Connect Series for JDBC Installation Guide. 0 and higher. To verify that the JDBC driver you need is configured correctly and is available for a database connection, choose Window > Preferences > Progress DB Navigator > JDBC Drivers. SQL support includes functions, expressions, aggregation, and joins including for collections with nested objects and arrays. A JDBC driver is a software component enabling a Java application to interact with a database.