For creating a new connection to a database that may or may not be hosted on your server, you necessarily do not need to create a new odbc connection. Follow the steps below to import the metadata:
1) create new connection pool
2) Select database source as OCI 10g/11g
3) Give the following information in the TNS section:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = hostname or IP addr)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ))
Change the TNS entry as per yours
4) Once done, give the username and password, and you should be good to go!!
Until Next Post... :)
No comments:
Post a Comment