Import using Oracle

[Former Member]

Hi,

I am trying to import file from oracle .Once I connect to repository in import manager,in the second window I have entered

Type:oracle

remote system:MDM

DBMS:service name

Database server:Host:Port(on which we have the source)

Username

Password

However I m getting Unable to connect to source error.

Kindly if sumone can resolve this.

MDM Server:SP06 patch 2]

Regards

Nisha

Edited by: Nisha L on Dec 23, 2008 6:04 AM

[Former Member]

Hi Nisha,

Try creating ODBC Connector for oracle database through Control Panel -> Administrative tools -> Data Sources (ODBC).

[Former Member]

Hi

Can u elaborate a bit more in details

Regards

Nisha

[Former Member]

By following above path open window for ODBC Data source administrator.

Click on Add button to create new Data source. It will list you all the available drivers, in that select "Microsoft ODBC for oracle", say Finish. It will ask you for DSN name, specify the DSN name, also description, user name & server name.

It will create DSN source, which you can access through import manager through "ODBC" option.

[Former Member]

Hi,

Do we need to have oracle client installed at my desktop for this?

Regards

Nisha

[rajasekhar_reddy14]

Hi Nisha.

If you want to conect to ORACLE, U hav to mainatin the conection details and Data Base Drivers in Data Sourse object.

No need to install oracle client,

Give driver name,data base name in Data Source object.

Cheers,

Raj

[Former Member]

Hi,

Sorry for replying late.While following the above mentioned procedure it is giving me an error "Oracle client and network components were not found"and doesnt allow me to create one.

Kindly if sumone can suggest regarding the same.

Regards

Nisha