3/25/2023 0 Comments Aqua data studio add driver![]() ![]() Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. OCI Connection to Oracle 12c and Oracle 12c Release 1.There is no need to change or update the drivers on OSX. OSX Users: OCI Connections are not supported on OSX. Please follow the appropriate link based upon the version of Oracle you have installed. The set of files that need to copied vary by Oracle version. The best way to ensure compatibility is to copy the Oracle JDBC drivers from your Oracle Client installation directory into ADS's drivers directory. To make an Oracle OCI Connection, you need to ensure that the Oracle JDBC drivers used by ADS are build compatible with the Oracle version you have installed on your machine.įailing to do this may cause ADS to crash. Making an OCI Connection to Oracle 12c/11g/10g/9i/8i Help > About > JDBC Drivers tab indicating 10g Drivers Using the Oracle 10g Drivers in Aqua Data Studio to Connect to Oracle 8i and 9iĪfter Deleting the Oracle 12c drivers and pasting the Oracle 10g JDBC drivers Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that the Oracle Driver is now at version 10.x. You must either delete these files or move them to a directory outside of Ĭopy the nls_charset12.jar, ojdbc14.jar and xdb6.jar file that you found in step 2 to \lib\drivers. Note: Renaming the files is not sufficient. Locate nls_charset12.jar, ojdbc14.jar and xdb6.jar within your Oracle installation.ĭelete ojdbc8.jar, orai18n.jar and xdb6.jar from \lib\drivers. Below are the instructions to backdrop to Oracle 10g drivers. Aqua Data studio still supports Oracle 8i and 9i, but you need to backdrop the Oracle drivers from 12c to 10g. Oracle has discontinued support for Oracle 8i and 9i in their Oracle 12c drivers. Making an OCI Connection to Oracle 12c/11g/10g/9i/8iĬonnecting to Oracle 8i and 9i using non-OCI ConnectionĪqua Data Studio is bundled with the Oracle 12c JDBC drivers.Connecting to Oracle 8i and 9i using non-OCI Connection.To make an OCI connection or to connect to Oracle 9i or 8i, please follow the appropriate instructions below. These drivers are compatible with Oracle 12c, 11g and 10g when using the Oracle (non-OCI) connection in Aqua Data Studio. Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Ī typical JDBC URL is below: jdbc:presto:Server=127.0.0.Aqua Data Studio comes bundled with Oracle 12c JDBC drivers. Password: The password used to authenticate to Kerberos.įor assistance in constructing the JDBC URL, use the connection string designer built into the Presto JDBC Driver.User: The user who is authenticating to Kerberos. ![]() KerberosKeytabFile: The Keytab file containing your pairs of Kerberos principals and encrypted keys.KerberosSPN: The Service Principal Name for the Kerberos Domain Controller.KerberosRealm: The Kerberos Realm used to authenticate the user with.KerberosKDC: The Kerberos Key Distribution Center (KDC) service used to authenticate the user.In order to authenticate with KERBEROS, set the following connection properties: Password: The password associated with the User you are authenticating against LDAP with.User: The username being authenticated with in LDAP.In order to authenticate with LDAP, set the following connection properties: Set the Server and Port connection properties to connect, in addition to any authentication properties that may be required. URL: Enter the JDBC URL, which starts with jdbc:presto: and is followed by a semicolon-separated list of connection properties. Driver: Enter the Driver's class name,.Driver Location: Click the Browse button and select the file, located in the lib subfolder of the installation directory.Name: Enter a name for the data source for example, Presto.Enter the following JDBC connection properties:.In the Register Server form, select the 'Generic - JDBC' connection.In Aqua Data Studio, select Register Server from the Servers menu.The Presto data source can then be accessed from Aqua Data Studio tools. You can use the connection manager to define connection properties and save them in a new JDBC data source. This article shows how to connect to Presto data through the connection manager and execute queries. The CData JDBC Driver for Presto integrates Presto data with wizards and analytics in IDEs like Aqua Data Studio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |