Acquiring data from a database - Latest

jdbc:hive2://<host>:<port>/<dbname>;[auth=noSasl] / [user=<username>;password=<password>]

If you are connecting to a Hive server 1 instance, replace hive2 with hive. By default, Hive uses port 10000.

You can use the AuthMech property to specify an alternative authentication method. For example, to configure Kerberos authentication, set the AuthMech property to 1.

Example with Kerberos authentication enabled:

jdbc:hive2://database-server@example.com:10000/default;principal=hive/hive2_<host>;AuthMech=1;KrbServiceName=hive;KrbHostFQDN=_mycluster.example.com;KrbRealm=example.com;LogLevel=4;LogPath=C:\Users\<user>\Downloads

DB2*

(A driver for the first option is shipped with your installation)

jdbc:db2://<host>:<port>/<dbname>

jdbc:as400://<host>:<port>/<dbname>

jdbc:derby://<host>:<port>/<dbname>;user=<username>;password=<password>

- or -

jdbc:derby://<host>:<port>/<path-dir>/<dbname>;user=<username>;password=<password>

jdbc:bigquery://<host>:<port>;ProjectId=<BigQuery project name>;OAuthType=<driver authentication type>

jdbc:hsqldb:file:C:/data/<dbname>

Specify a file path that is either a relative or absolute path to the database file.

jdbc:jtds:sqlserver://<host>/<dbname>;instance=<instancename>

To use authenticated security, append the domain and userNTLMv2 properties as follows:

jdbc:jtds:sqlserver://<host>/<dbname>;instance=<instancename>;domain=<domainname>;useNTLMv2=true

MariaDB*

(can be used to access MySQL)

jdbc:mariadb://<host>:<port>/<dbname>

To use SSH, append "useSSL=true&serverSslCert=<path to server SSL certificate>" for example: jdbc:mariadb://<host>:<port>/<dbname>;useSSL=true&serverSslCert=<path to server SSL certificate>

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

To access SQL Server in Windows Authentication mode, append;authenticationScheme=NTLM;domain=<Domain Value>;integratedSecurity=trueand enter your Windows credentials in theDbUserandDbPasswordproperties.

For example:

jdbc:sqlserver://localhost:63369;authenticationScheme=NTLM;domain=<domain value>;integratedSecurity=true

Using this format allows you to specify a Windows domain, username and password that are different to the signed-in user of the PC, or the user running Data360 Analyze, if desired.

If you are connecting to a database in Azure, you must also include ;authentication=ActiveDirectoryIntegrated in the connection string. Additionally, to allow the system user's ID to be accessible to the Azure Active Directory system, the on-premise Active Directory must be federated with the Azure Active Directory.

When using Windows Authentication, you can also simply append ;integratedSecurity=true,and leave the DbUser and DbPassword properties empty, to use the current user for Windows authentication.

In this case, the signed-in user of the PC is the current user, for a desktop instance. For a server instance, the service account used to run theData360 Analyzeapplication is the current user, as opposed to the end-user accessing the server instance through their browser.

jdbc:ucanaccess://<path-to-db>

For example:

jdbc:ucanaccess://c:/users/temp/myDB.mdb

jdbc:netezza://<host>:<port>/<dbname>

There are several ways to connect to an Oracle database over the thin client:

1. Use Oracle SID:

   jdbc:oracle:thin:@//<host>:<port>:<system identifier (SID)>

   For example, if the database to which you want to connect resides on host prodHost, at port 1521, and the system identifier is ORCL: jdbc:oracle:thin:@prodHost:1521:ORCL

   - or -

2. Use a Service Name:

   jdbc:oracle:thin:@//<host>:<port>/<service name>

   For example: jdbc:oracle:thin:@//myhost:1521/myservicename

   - or -

3. Use the full TNS keyword-value syntax:

   For example if the database to which you want to connect resides on host prodHost, at port 1521, and the system identifier is ORCL: jdbc:oracle:thin:@(description=(address_list=(address=(protocol=tcp)(port=1521)(host=prodHost)))(connect_data=(INSTANCE_NAME=ORCL)))

Alternatively, to connect using the Oracle TNSnames system, you can do the following:

1. Enter your query and credentials.
2. In the DbType property, select Oracle.
3. Do not enter any value in the DbName or DbHost properties.
4. In the DbUrl property, enter: jdbc:oracle:thin:@<TNSName>
5. In the JvmProperties property, add a reference to the folder that contains the tnsnames.ora file, for example: oracle.net.tns_admin=/path/to/oracle/network/admin/

jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>

<account_name> is the full name of your account, provided by Snowflake.

<connection_params> is a series of one or more parameters in the format <parameter>=<value>

Include your schema details in the URL, or in the DbOptions property, in the following format: schema=<YourSchema>

For more information, see the Snowflake documentation: https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html#jdbc-driver-connection-string