{"id":17718,"date":"2024-07-11T14:54:48","date_gmt":"2024-07-11T18:54:48","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=17718"},"modified":"2024-07-15T11:37:03","modified_gmt":"2024-07-15T15:37:03","slug":"oracle-tls-support","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/oracle-tls-support\/","title":{"rendered":"Oracle TLS Support"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">To configure both JDBC and ODBC to support the Transport Layer Security (TLS) protocol, there are additional configuration steps that are needed when compared to this <\/span><a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-iri-software-oracle\/\"><span style=\"font-weight: 400;\">previous article<\/span><\/a><span style=\"font-weight: 400;\">. This article is not a replacement but to add additional information about the steps needed for TLS connections.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once the connections are established, this the graphical <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> IDE and the CoSort <\/span><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\"><span style=\"font-weight: 400;\">SortCL engine<\/span><\/a><span style=\"font-weight: 400;\"> can combine to perform: <\/span><i><span style=\"font-weight: 400;\">data integration and migration, data wrangling and reporting, data discovery and auditing, data masking and cleansing, data synthesis and subsetting, and more<\/span><\/i><span style=\"font-weight: 400;\">, over an encrypted connection to the Oracle database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Oracle has a wide range of configurations when it comes to connecting clients to the database server. This article will explain important concepts related to Oracle, required files to download for TLS connections, and a <\/span><a href=\"https:\/\/youtu.be\/yYagMd9dDjA?si=Rz8bTbsTj15yPOKQ\"><span style=\"font-weight: 400;\">YouTube tutorial<\/span><\/a><span style=\"font-weight: 400;\"> on how to set everything up in IRI Workbench. Other configuration options are outside the scope of this article.<\/span><\/p>\n<h4><strong>Required Information and Files<\/strong><\/h4>\n<p><span style=\"font-weight: 400;\">Oracle uses several files and utilities to set up different configuration options to connect to the server. In the following sections, background information will be provided on the Oracle wallet, orapki utility, sqlnet.ora and tnsnames.ora files required to set up the TLS connection.<\/span><\/p>\n<h6><span style=\"font-weight: 400;\">Oracle Wallet<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">Oracle uses a \u201cwallet\u201d to contain the certificates needed for the TLS handshake to work. The oracle wallet is not automatically created, so this will have to be provided by the Database Administrator (DBA) or created on the client machine .<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For the TLS handshake to work, there are two certificates that are needed:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The server certificate<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The client certificate<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">A Client Wallet needs to import the <\/span><i><span style=\"font-weight: 400;\">Server Certificate<\/span><\/i><span style=\"font-weight: 400;\"> in order for the client machine to validate and trust the server. The server wallet also needs to import the <\/span><i><span style=\"font-weight: 400;\">client certificate <\/span><\/i><span style=\"font-weight: 400;\">to validate and trust the client. If the DBA provides the client wallet then the importing of certificates should already be done.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17722\" src=\"\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme-300x98.png\" alt=\"\" width=\"732\" height=\"239\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme-300x98.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme-1024x333.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme-768x250.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme-1536x499.png 1536w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Client-wallet-scheme.png 1110w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/p>\n<h6><span style=\"font-weight: 400;\">Orapki Utility<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">To create the wallet, the client machine needs to have the CLI tool called <\/span><a href=\"https:\/\/docs.oracle.com\/en\/middleware\/fusion-middleware\/12.2.1.3\/asadm\/orapki.html\"><span style=\"font-weight: 400;\">orapki<\/span><\/a><span style=\"font-weight: 400;\">. This utility will allow the client to create and manage the wallet. Orapki is included in the <\/span><a href=\"https:\/\/www.oracle.com\/database\/technologies\/oracle19c-windows-downloads.html\"><span style=\"font-weight: 400;\">Oracle Database (version) Client<\/span><\/a><span style=\"font-weight: 400;\">, but is not included in the instant client version.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">*** Note: the previous link is for Oracle 19c. Google \u201cOracle database (your database version) client download\u201d for your specific Oracle version.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Having orapki downloaded onto the client machine is recommended since it will help manage and address any issues connecting to the database server using the wallet. If the DBA is providing the client wallet, the password to the wallet is needed to manipulate said wallet.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Useful orapki commands (<\/span><i><span style=\"font-weight: 400;\">replace the bold sections<\/span><\/i><span style=\"font-weight: 400;\">):<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Display certificates inside the wallet<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">orapki wallet display -wallet <\/span><b>pathToWallet <\/b><span style=\"font-weight: 400;\">-pwd <\/span><b>pwdForWallet<\/b><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Import certificates to the wallet\u2019s trusted certificates<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">orapki wallet add -wallet <\/span><b>wallet_location<\/b><span style=\"font-weight: 400;\"> -trusted_cert -cert <\/span><b>certificate_location<\/b><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a wallet<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">orapki wallet create -wallet <\/span><b>wallet_location<\/b><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><b>*** <\/b><span style=\"font-weight: 400;\">Note: pwd stands for password<\/span><\/p>\n<h6><span style=\"font-weight: 400;\">Tnsnames.ora<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">Since the client machine can host multiple applications that will need to connect to different databases, the use of sqlnet.ora and tnsnames.ora files are used to centralize the configuration parameters.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><br \/>\n<\/span><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/netrf\/local-naming-parameters-in-tns-ora-file.html\"><span style=\"font-weight: 400;\">Tnsnames.ora<\/span><\/a><span style=\"font-weight: 400;\"> file is a SQL*Net configuration file that defines database addresses for establishing connections to them. This will allow the user to centralize all the connection information needed to interact with databases and specify what protocols to use.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Common directories to find the tnsnames.ora file are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">ORACLE_HOME\/network\/admin\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">oracle\/instantclient_[database_version]\/network\/admin<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For tnsname.ora file, provide the following information:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The IP address of the server or the host name<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The port number<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The protocol used<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Transmission Control Protocol Secures (TCPS) for TLS\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Transmission Control Protocol (TCP) for an unencrypted connection<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Oracle wallet directory<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Only needed for TLS<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The database service name.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">The example entry below is connecting to a database server using the protocol TCPS and is providing the directory to the client wallet. Oracle is particular about the placement of certain information and uses parentheses to group related information together, which can be the cause of some errors when first setting up a connection.<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">FREE_SSL=<\/span>\r\n<span style=\"font-weight: 400;\">      (DESCRIPTION=<\/span>\r\n<span style=\"font-weight: 400;\">            (ADDRESS=(<\/span><b>PROTOCOL=TCPS<\/b><span style=\"font-weight: 400;\">)(HOST=192.168.3.170)(PORT= 2484))<\/span>\r\n<span style=\"font-weight: 400;\">            (SECURITY=(<\/span><b>WALLET_LOCATION<\/b><span style=\"font-weight: 400;\">=C:\\Oracle\\instantclient_21_11\\network\\admin\\clientWallet))<\/span>\r\n<span style=\"font-weight: 400;\">            (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=FREE)))<\/span><\/pre>\n<h6><span style=\"font-weight: 400;\">Sqlnet.ora<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">The <\/span><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/netrf\/parameters-for-the-sqlnet.ora.html\"><span style=\"font-weight: 400;\">sqlnet.ora<\/span><\/a><span style=\"font-weight: 400;\"> file is the profile configuration file which resides on the client machines and the database server. The file enables you to do the following:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Specify the client domain to append to unqualified names<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Prioritize naming methods<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enable logging and tracing features<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Route connections through specific processes<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Configure Oracle Advanced Security<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use protocol-specific parameters to restrict access to the database<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sqlnet.ora file can be found in the same directories as the tnsnames.ora file. In this file, the only two parameters needed are the<\/span><i><span style=\"font-weight: 400;\"> WALLET_LOCATION <\/span><\/i><span style=\"font-weight: 400;\">and <\/span><i><span style=\"font-weight: 400;\">SSL_CLIENT_AUTHENTICATION<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The example entry below points to the directory of the wallet and sets the client authentication parameter to false. Authentication will still be performed in the JDBC\/ODBC connections since the user credentials will be provided.<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)<\/span>\r\n<b>SSL_CLIENT_AUTHENTICATION<\/b><span style=\"font-weight: 400;\">=FALSE<\/span>\r\n\r\n<b>WALLET_LOCATION<\/b><span style=\"font-weight: 400;\">=C:\\Oracle\\instantclient_21_11\\network\\admin\\clientWallet<\/span><\/pre>\n<h6><span style=\"font-weight: 400;\">Required JAR Files<\/span><\/h6>\n<p><span style=\"font-weight: 400;\">Additional JAR file(s) are needed for the JDBC JAR file to use the Oracle wallet for the TLS connection. Depending on the Oracle database version, the required JAR files are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Oraclepki.jar<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Osdt_core.jar<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Osdt_cert.jar<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Use the provided <\/span><a href=\"https:\/\/www.oracle.com\/database\/technologies\/appdev\/jdbc-downloads.html\"><span style=\"font-weight: 400;\">link<\/span><\/a><span style=\"font-weight: 400;\"> to download the \u201c<\/span><i><span style=\"font-weight: 400;\">Zipped JDBC Driver and Companion Jars<\/span><\/i><span style=\"font-weight: 400;\">\u201d for the specific database version required and JDK17 supported.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">*** Note: Newer versions of Oracle will only need the oraclepki.jar file and will not provide the other two jar files as part of the zipped file.<\/span><\/p>\n<h4><strong>JDBC and ODBC<\/strong><\/h4>\n<p><span style=\"font-weight: 400;\">ODBC connection is simple to set up because the only thing that changes is providing the TNS name in the tnsnames.ora file that is connecting to the desired database with the TCPS protocol.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The JDBC URL has the biggest change and depending on what additional configurations are set up, IRI Workbench now includes a custom URL parameter to allow the user to paste the URL and its additional parameters. Since all JDBC URLs have to start with the same prefix (jdbc:oracle:thin:@), only include the additional URL parameters in the text box.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The image below shows an example of the changes in IRI Workbench. The URL is using the Oracle wallet and the TCPS protocol to connect to the database.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17723\" src=\"\/blog\/wp-content\/uploads\/2024\/07\/example-of-the-changes-in-IRI-Workbench-300x136.png\" alt=\"\" width=\"758\" height=\"344\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/example-of-the-changes-in-IRI-Workbench-300x136.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/example-of-the-changes-in-IRI-Workbench-768x348.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/example-of-the-changes-in-IRI-Workbench.png 771w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The syntax used in the<\/span><i><span style=\"font-weight: 400;\"> Custom URL<\/span><\/i><span style=\"font-weight: 400;\"> is:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=ip_address\/hostName)(PORT=portNumber))<\/span>\r\n<span style=\"font-weight: 400;\">(SECURITY=(WALLET_LOCATION=directoryToWallet))(CONNECT_DATA=(SERVER=DEDICATED)<\/span>\r\n<span style=\"font-weight: 400;\">(SERVICE_NAME=placeHolder)))<\/span><\/pre>\n<p><span style=\"font-weight: 400;\">*** Note: In a future update, the use of the TNS name for JDBC URL will be supported.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With all the required files downloaded and an understanding of how the files work to set up the database connections, watch the YouTube tutorial which will go step by step on setting up the drivers for IRI Workbench and SortCL:<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"How to Connect: Oracle DB to IRI Workbench using TLS\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/yYagMd9dDjA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><span style=\"font-weight: 400;\">If you have any questions about this article or need help setting up IRI software in this environment, please email <\/span><a href=\"mailto:voracity@iri.com\"><span style=\"font-weight: 400;\">voracity@iri.com<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To configure both JDBC and ODBC to support the Transport Layer Security (TLS) protocol, there are additional configuration steps that are needed when compared to this previous article. This article is not a replacement but to add additional information about the steps needed for TLS connections.\u00a0 Once the connections are established, this the graphical IRI<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/oracle-tls-support\/\" title=\"Oracle TLS Support\">Read More<\/a><\/div>\n","protected":false},"author":160,"featured_media":17727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,363,1,776,91],"tags":[1831,20,107,14,77,15,1837,1163,1836,203,850,1834,1835,1828,1832,1833,1830,1838,1829,1839],"class_list":["post-17718","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-quality","category-data-transformation2","category-etl","category-iri-workbench","tag-cosort-sortcl","tag-data-anonymization","tag-data-integration","tag-data-masking","tag-data-migration-2","tag-data-security","tag-data-synthesis","tag-data-wrangling","tag-database-connection","tag-encryption","tag-iri-workbench","tag-jdbc-setup","tag-odbc-setup","tag-oracle-database","tag-oracle-wallet","tag-orapki-utility","tag-secure-connections","tag-sqlnet-ora","tag-tls-configuration","tag-tnsnames-ora"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle TLS Support - IRI<\/title>\n<meta name=\"description\" content=\"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions &amp; YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle TLS Support\" \/>\n<meta property=\"og:description\" content=\"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions &amp; YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-11T18:54:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-15T15:37:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1110\" \/>\n\t<meta property=\"og:image:height\" content=\"532\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kevin Roldos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin Roldos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\"},\"author\":{\"name\":\"Kevin Roldos\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\"},\"headline\":\"Oracle TLS Support\",\"datePublished\":\"2024-07-11T18:54:48+00:00\",\"dateModified\":\"2024-07-15T15:37:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\"},\"wordCount\":1128,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png\",\"keywords\":[\"CoSort SortCL\",\"data anonymization\",\"data integration\",\"data masking\",\"data migration\",\"data security\",\"Data Synthesis\",\"data wrangling\",\"Database Connection\",\"encryption\",\"IRI Workbench\",\"JDBC Setup\",\"ODBC Setup\",\"Oracle Database\",\"Oracle Wallet\",\"Orapki Utility\",\"Secure Connections\",\"SQLnet.ora\",\"TLS Configuration\",\"tnsnames.ora\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Quality (DQ&#041;\",\"Data Transformation\",\"ETL\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\",\"name\":\"Oracle TLS Support - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png\",\"datePublished\":\"2024-07-11T18:54:48+00:00\",\"dateModified\":\"2024-07-15T15:37:03+00:00\",\"description\":\"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions & YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png\",\"width\":1110,\"height\":532},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle TLS Support\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\",\"name\":\"Kevin Roldos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g\",\"caption\":\"Kevin Roldos\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/kevinr\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle TLS Support - IRI","description":"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions & YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/","og_locale":"en_US","og_type":"article","og_title":"Oracle TLS Support","og_description":"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions & YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/","og_site_name":"IRI","article_published_time":"2024-07-11T18:54:48+00:00","article_modified_time":"2024-07-15T15:37:03+00:00","og_image":[{"width":1110,"height":532,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","type":"image\/png"}],"author":"Kevin Roldos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Roldos","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/"},"author":{"name":"Kevin Roldos","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0"},"headline":"Oracle TLS Support","datePublished":"2024-07-11T18:54:48+00:00","dateModified":"2024-07-15T15:37:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/"},"wordCount":1128,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","keywords":["CoSort SortCL","data anonymization","data integration","data masking","data migration","data security","Data Synthesis","data wrangling","Database Connection","encryption","IRI Workbench","JDBC Setup","ODBC Setup","Oracle Database","Oracle Wallet","Orapki Utility","Secure Connections","SQLnet.ora","TLS Configuration","tnsnames.ora"],"articleSection":["Data Masking\/Protection","Data Quality (DQ&#041;","Data Transformation","ETL","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/","name":"Oracle TLS Support - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","datePublished":"2024-07-11T18:54:48+00:00","dateModified":"2024-07-15T15:37:03+00:00","description":"Learn how to configure JDBC and ODBC for Transport Layer Security (TLS) with IRI Voracity. This guide covers essential steps, including setting up Oracle Wallet, using the orapki utility, and configuring sqlnet.ora and tnsnames.ora files. Follow our instructions & YouTube tutorial to securely connect IRI Workbench and CoSort to Oracle databases, enabling encrypted data integration, migration, masking, and more.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","width":1110,"height":532},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/oracle-tls-support\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle TLS Support"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0","name":"Kevin Roldos","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g","caption":"Kevin Roldos"},"url":"https:\/\/www.iri.com\/blog\/author\/kevinr\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/07\/Featured-image-Oracle-TLS-support.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17718"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/160"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=17718"}],"version-history":[{"count":7,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17718\/revisions"}],"predecessor-version":[{"id":17752,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17718\/revisions\/17752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/17727"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=17718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=17718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=17718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}