Click Connect to Data. On the Connect page, click Other Databases (ODBC). In the DSN drop-down list, select the name that you gave to your Oracle BI Server ODBC connection, and then click Connect. Below is the link on how to connect with the BI Connector. How to Connect to Oracle BI Server with Tableau without the shortcomings of Oracle ODBC driver. This archive contains the latest 19.3 JDBC Thin driver (ojdbc10.jar), the Universal Connection Pool (ucp.jar), their Readme(s) and companion jars.(8,051,416 bytes.

If you are connecting to an SSL (security socket layer) server, check the Require SSL check box.

Beginning in 2020.2, Oracle uses a JDBC connector. If your Oracle data source is configured to use SSL one-way or two-way authentication, you can include the appropriate certificates and/or key to connect.

Require SSL

If your connection requires SSL, do the following:

  1. From the connector dialog, click Require SSL.
  2. Configure SSL as appropriate for your connection:
    • If you are using self-signed certificates or a certificate from signed by a private CA, you may need to configure trust for one-way SSL connections. See Configure one-way SSL for Oracle.
    • If you are using two way SSL, you will need to configure your client keys. See Configure two-way SSL.

Configure one-way SSL for Oracle

To configure trust for your server certificate, see general instructions for JDBC connectors here: Configure One-Way SSL for JDBC Connections.

If you decide to use properties files to configure trust, then use the following properties for the Oracle JDBC driver.

javax.net.ssl.trustStore=C:My_Foldertruststore.jks
javax.net.ssl.trustStoreType=JKS
javax.net.ssl.trustStorePassword=password

Note: To publish a workbook to Tableau Server, both the Tableau Desktop and Tableau Server computers must have copies of the same Oracle properties file and truststore.jks file.

Configure two-way SSL

There are two options for configuring two-way SSL support with an Oracle connection:

Tableau desktop oracle driver update

Option 1: Embed client certificates and private key in the data source

To embed an SSL certificate, client certificate, and client key:

  1. Follow the steps in Configure one-way SSL for Oracle to configure server trust, if necessary.
  2. Click Client Certificate >>.
  3. Specify the locations for the client certificate and client key.
    The certificate and private key should be in unencrypted PEM format. See instructions later in this document for suggestions on converting to the correct format.

Option 2: Use a properties file to configure the client certificate and private key

To use a properties file for certificate and key configuration:

  1. Modify the oracle.properties file to reflect the key store and trust store settings. Use the following as an example. Be sure to replace “My_Folder” for the location of your files and “<password>” with your own password. Paths on OSX and Linux need only a single '/' to separate.

    javax.net.ssl.trustStore=C:My_Foldertruststore.jks
    javax.net.ssl.trustStoreType=JKS
    javax.net.ssl.trustStorePassword=<password>
    javax.net.ssl.keyStore=C:My_Folderkeystore.jks
    javax.net.ssl.keyStoreType=JKS
    javax.net.ssl.keyStorePassword=password

  2. Save oracle.properties to the <Document>MyTableau RespositoryDatasources folder.
  3. Copy oracle.properties, truststore.jks, and keystore.jks to the Tableau Server computer. This allows the workbook to be published to the Tableau Server.

If you use this method, you don't need to upload certificates and key via the SSL dialog. Instead, simply click Require SSL. This causes the Oracle JDBC connector to read the locations of the key store and trust store from oracle.properties file.

Publish a workbook

To publish a workbook to Tableau Server, be sure the following are true:

  • If you use a properties file, both the Tableau Desktop and Tableau Server computers have copies of the same Oracle properties file, truststore.jks, and keystore.jks.
  • The server uses the same Oracle JDBC connector as the Tableau Desktop computer.
  • If you used the embedding option, select “embed password” option when you publish.

Convert key formats

There are several formats for storing SSL keys, including:

Tableau tnsnames
  • Oracle Wallet
  • JKS - Use this format if you want to configure SSL trust using properties files.
  • PEM - Use this format if you want to embed the keys in the data source using Tableau interface.

The following are some suggested commands you can type at the command-line prompt to convert keys to the correct format. See the Oracle documentation for the more details.

To export server certificate from an Oracle wallet to PEM file:

orapki wallet export -wallet wallet_location -dn certificate_dn -cert output_certificate_filename.pem

To export server certificate and client keys from Oracle wallet to JKS:

orapki wallet pkcs12_to_jks -wallet ./ -pwd mypasswd -jksKeyStoreLoc ./ewalletK.jks -jksKeyStorepwd password -jksTrustStoreLoc ./ewalletT.jks -jksTrustStorepwd password

To export server certificate from JKS trust store to PEM file using keytool and OpenSSL:

  1. Export JKS format to PKCS12 format:

    keytool -importkeystore -srckeystore truststore.jks -destkeystore truststore.p12 -srcstoretype JKS -deststoretype PKCS12 -srcstorepass 'password' -deststorepass 'password'

  2. Get the PEM file from PKCS12:

    openssl pkcs12 -in truststore.p12 -out serverca.pem

Tableau Desktop Oracle Driver Windows 7

To export server certificate and client keys from JKS trust store to PEM file using keytool and OpenSSL:

  1. Export the certificate from the trust store as follows.
    1. Export JKS format to PKCS12 format:

      keytool -importkeystore -srckeystore truststore.jks -destkeystore truststore.p12 -srcstoretype JKS -deststoretype PKCS12 -srcstorepass 'password' -deststorepass 'password'

    2. Get the PEM file from PKCS12:

      openssl pkcs12 -in truststore.p12 -out serverca.pem

  2. Export the client key and client certificate from the key store as follows.
    1. Use keytool to transform JKS format to PCKS12 format:

      keytool.exe -importkeystore -srckeystore keystore.jks -destkeystore keystore.p12 -srcstoretype JKS -deststoretype PKCS12 -srcstorepass 'password' -deststorepass 'password'

    2. Use OpenSSL to export the client certificate:

      openssl pkcs12 -in keystore.p12 -nokeys -out clientcert.pem

    3. Use OpenSSL to export the client key:

      openssl pkcs12 -in keystore.p12 -nocerts -out clientkeyEncrypted.pem

    4. Use OpenSSL to transform the encrypted version to PKCS8 format:

      openssl pkcs8 -topk8 -nocrypt -in clientkeyEncrypted.pem -out clientkey.pem

See also

  • Configure SSL for JDBC Connections - More general information about installing trusted SSL certificates for JDBC connections.
Thanks for your feedback!Tableau

Related searches

  • » tableau oracle driver
  • » tableau 10 oracle driver
  • » tableau oracle driver 8.3
  • » installer tableau driver oracle software
  • » tableau oracle driver download
  • » oracle driver tableau
  • » driver oracle tableau
  • » tableau macros in excel tableau add-in
  • » tableau excel 2016 add in for tableau
  • » 下载安装 tableau oracle

oracle driver for tableau

at UpdateStar
  • More

    Tableau Oracle Driver

  • More

    Realtek High Definition Audio Driver 6.0.9088.1

    REALTEK Semiconductor Corp. - 168.6MB - Freeware -
    Audio chipsets from Realtek are used in motherboards from many different manufacturers. If you have such a motherboard, you can use the drivers provided by Realtek. more info...
  • More

    Java Update 8.0.2910.10

    The Java SE Runtime Environment contains the Java virtual machine,runtime class libraries, and Java application launcher that arenecessary to run programs written in the Java programming language.It is not a development environment and … more info...
  • More

    Realtek Ethernet Controller Driver 10.48.315.2021

    This package installs the software (Ethernet Controller driver). more info...
  • More

    Driver Booster 8.4.0.422

    Driver Booster 4, as a powerful and easy-to-use driver updater, provides 1-click solution to rapidly & securely update outdated and faulty drivers and install the best matched missing drivers not only for your device drivers but also for … more info...
  • More

    NVIDIA Graphics Driver 466.27

    Supported Products:GeForce 500 series:GTX 590, GTX 580, GTX 570, GTX 560 Ti, GTX 560, GTX 550 Ti, GT 545, GT 530, GT 520, 510GeForce 400 series:GTX 480, GTX 470, GTX 465, GTX 460 v2, GTX 460 SE v2, GTX 460 SE, GTX 460, GTS 450, GT 440, GT … more info...
  • More

    NVIDIA HD Audio Driver 1.3.38.40

    High Definition Audio Driver for NVIDIA devices. more info...
  • More

    SAMSUNG USB Driver for Mobile Phones 1.7.31

    Samsung Electronics Co., Ltd. - 38.9MB - Freeware -
    Samsung USB Driver for Android Cell Phones & Tablets more info...
  • More

    Intel Graphics Media Accelerator Driver 15.17.9.2182

    Intel Graphics Media Accelerator Driver is a graphics driver for Intel GMA based motherboards. more info...
  • More

    Intel Driver & Support Assistant 21.2.13.9

    The Intel® Driver & Support Assistant enables you to scan computing devices for the latest drivers available from Intel. This tool has the main interface hosted on Intel’s support website and provides a more integrated support experience … more info...
Tableau Desktop Oracle Driver
Descriptions containing

oracle driver for tableau

  • More

    Realtek High Definition Audio Driver 6.0.9088.1

    REALTEK Semiconductor Corp. - 168.6MB - Freeware -
    Audio chipsets from Realtek are used in motherboards from many different manufacturers. If you have such a motherboard, you can use the drivers provided by Realtek. more info...
  • More

    Realtek Ethernet Controller Driver 10.48.315.2021

    This package installs the software (Ethernet Controller driver). more info...
  • More

    NVIDIA HD Audio Driver 1.3.38.40

    High Definition Audio Driver for NVIDIA devices. more info...
  • More

    SAMSUNG USB Driver for Mobile Phones 1.7.31

    Samsung Electronics Co., Ltd. - 38.9MB - Freeware -
    Samsung USB Driver for Android Cell Phones & Tablets more info...
  • More

    Microsoft .NET Framework 5.0.3

    The Microsoft .NET Framework 4 Client Profile redistributable package installs the .NET Framework runtime and associated files that are required to run most client applications.The .NET Framework is Microsoft's comprehensive and consistent … more info...
  • More

    Intel Graphics Media Accelerator Driver 15.17.9.2182

    Intel Graphics Media Accelerator Driver is a graphics driver for Intel GMA based motherboards. more info...
  • More

    NVIDIA GeForce Experience 3.22.0.32

    NVIDIA GeForce Experience is a powerful application that is especially designed to provide you with a means of having the best settings for your games as well as the latest drivers from NVIDIA. more info...
  • More

    Realtek USB Card Reader 6.2.9200.39041

    USB card reader driver for Win XP/Vista/Win7 more info...
  • More

    Intel Processor Graphics 27.20.100.7989

    Intel X3000 Chipset incorporates key features available in previous Intel Graphics versions like Dynamic Video Memory Technology (DVMT) as well as hardware acceleration for 3D graphics that utilize Microsoft DirectX* 9.0C and OpenGL* 1.5X. more info...
  • More

    Driver Booster 8.4.0.422

    Driver Booster 4, as a powerful and easy-to-use driver updater, provides 1-click solution to rapidly & securely update outdated and faulty drivers and install the best matched missing drivers not only for your device drivers but also for … more info...
Additional titles containing

oracle driver for tableau

Tableau Desktop Oracle Drivers

  • More

    Realtek High Definition Audio Driver 6.0.9088.1

    REALTEK Semiconductor Corp. - 168.6MB - Freeware -
    Audio chipsets from Realtek are used in motherboards from many different manufacturers. If you have such a motherboard, you can use the drivers provided by Realtek. more info...
  • More

    Realtek Ethernet Controller Driver 10.48.315.2021

    This package installs the software (Ethernet Controller driver). more info...
  • More

    NVIDIA Graphics Driver 466.27

    Supported Products:GeForce 500 series:GTX 590, GTX 580, GTX 570, GTX 560 Ti, GTX 560, GTX 550 Ti, GT 545, GT 530, GT 520, 510GeForce 400 series:GTX 480, GTX 470, GTX 465, GTX 460 v2, GTX 460 SE v2, GTX 460 SE, GTX 460, GTS 450, GT 440, GT … more info...
  • More

    NVIDIA HD Audio Driver 1.3.38.40

    High Definition Audio Driver for NVIDIA devices. more info...
  • More

    Driver Booster 8.4.0.422

    Driver Booster 4, as a powerful and easy-to-use driver updater, provides 1-click solution to rapidly & securely update outdated and faulty drivers and install the best matched missing drivers not only for your device drivers but also for … more info...

Most recent searches

Tableau Desktop Oracle Driver

  • » glary tracks eraser 5.0.1.189
  • » cbc ereporting
  • » ulead photo express 3 windows 10
  • » filou11 lizence key
  • » baixar extençao jnlp
  • » print control proxy windows 10 download
  • » super naughty
  • » descargar 5nine v2v easy converter
  • » watsab dowlod
  • » need ford speed letöltése
  • » obs asio download
  • » teamviver 15 indir
  • » ldra testbed破解版下载
  • » 特戰英豪 下載
  • » download spss 25.0
  • » outbit driver udadter
  • » 사운드포지 무료 버전
  • » papyrus pulgin
  • » descargar kmspico.zip
  • » gta vc tokyo drift
Coments are closed

Most Viewed Posts

  • Must Watch Movies In Amazon Prime
  • Tor Safari
  • Merge Data

Scroll to top