How To Create A Dsn For Oracle

Abstract
Supported Versions
Connecting to Oracle Database Cloud Service from Informatica Developer or PowerCenter
- Overview
- Configure the ODBC Data Source on Windows
- Configuring the Oracle Client for Oracle Database Cloud Service to Read or Write Data
  - Configuring SQLNET.ORA and TNSNAMES.ORA Files with Wallet Information
  - Verifying Connectivity from Oracle Client to Oracle Database Cloud Service with SQL *Plus
  - Creating an Oracle Connection from the Developer Tool
  - Creating an Oracle Connection from PowerCenter

Connecting to Oracle Database Cloud Service from Informatica Developer or PowerCenter

Configure the ODBC Data Source on Windows

You must create the ODBC data source for Oracle Database Cloud Service so that you can import the metadata and preview the data from the Developer tool or PowerCenter Client.

Create the data source on the machine where you installed the Developer tool or the PowerCenter Client. Configure the data source in the ODBC Data Source Administrator. You must create the 32-bit data source for the PowerCenter Client and the 64-bit data source for the Developer tool.

To start the ODBC Data Source Administrator wizard, perform one of the following tasks:

To create a 32-bit data source for the PowerCenter Client, open the Control Panel and click

Administrative Tools

. Then, double-click

ODBC Data Sources (32-bit)

Alternatively, enter the following command at the command prompt:

%windir%\SysWOW64\odbcad32.exe

To create a 64-bit data source for the Developer tool, open the Control Panel and click

Administrative Tools

. Then, double-click

ODBC Data Sources (64-bit)

Alternatively, enter the following command at the command prompt:

%windir%\System32\Odbcad32.exe

The

ODBC Data Source Administrator

wizard appears.

On the

System DSN

tab, click

Add

In the

Create a New Data Source

dialog box, select

DataDirect 8.0 Oracle Wire Protocol

from the list of available drivers, and click

Finish

On the

General

tab of the

ODBC Oracle Wire Protocol Driver Setup

dialog box, enter the data source name, host name, port number, and service name for Oracle Database Cloud Service that you want to connect to.

The following image shows the

ODBC Oracle Wire Protocol Driver Setup

dialog box with the configured details:

You can view the Oracle Database Cloud Service DSN details.

On the

Security

tab, configure the following encryption properties:

Encryption Method

Get the value for SSL_VERSION in the database from your database administrator. For example, select

3-SSL3

if the SSL_VERSION in the database configuration is 3.0.

Validate Server Certificate

Enable this option if you want to validate the server certificate.

Trust Store

Enter the absolute path for the truststore

.p12

file.

Trust Store Password

Specify the password for the

.p12

truststore file.

Key Store

Enter the absolute path of the Oracle keystore

.p12

file.

Key Store Password

Specify the keystore password for

.p12

keystore file.

Key Password

Specify the key password. This field is optional.

Host Name in Certificate

You must get the host name details from the database administrator. Enter the name of the database server specified in the server SSL certificate.

The following image shows the DataDirect 8.0 Oracle Wire protocol setup where you configure the security settings:

You can view the encryption and authentication details.

Click

to create the ODBC data source for Oracle Database Cloud Service.

Updated May 09, 2021

How To Create A Dsn For Oracle

Source: https://docs.informatica.com/data-integration/powercenter/h2l/1215-connecting-to-oracle-database-cloud-service-from-informatic/connecting-to-oracle-database-cloud-service-from-informatica-dev/configure-the-odbc-data-source-on-windows.html

Posted by: robinsongree1943.blogspot.com