File to JDBC Scenario

[Former Member]

Hi all,

My scerio : File --XI ---JDBC scenario

JDBC is oracle DB

how to give connection parameters for an oracle.

[Former Member · Accepted solution]

Follow below blog

Connection parameter & jdbc drivers changes

connection string : jdbc:oracle:oci8:userid/password@server

Note that this connection string is only if you use the Oracle OCI driver. The OCI driver requires a shared library or DLL on the server.

The thin driver for Oracle is more commonly used as it doesn't require any additional libraries. The connection string is as already listed above:

jdbc.oracle.thin:@server:port:SID

Follow this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

For all type of Jdbc drivers

http://www.devx.com/tips/tip/28818

[dharamveer_gaur2]

UserName: <username of oracle>

Password: Password to correspondent user

Driver:driver: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@hostName:1521:SID

here host name :Name or IP of oracle server

1521:default port

SID:Suytem ID(Global Database Name) of oracle(if you dont know ask database Admin)

Edited by: Dharamveer Gaur on Sep 15, 2008 12:47 PM

[Former Member]

Hi,

For Oracle:

JDBC Driver is: oracle.jdbc.driver.OracleDriver

Connection Parameter is: jdbc:oracle:thin:@<HostName>:1521:<SID>

Where SID is the database name which we are going to access and host name is the IP

address

Regards

Seshagiri

[former_member192295]

Hi,

Generally JDBC driver and connection string parameters are getting from basis team, we can find driver information through below link

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html

For scenario configuration

Below one the syntax for connection string

jdbc:oracle:thin:@<HostName>:<Port>:<Data Base Name>

[former_member183906]

Hii

For Oracle:

JDBC Driver is: oracle.jdbc.driver.OracleDriver

Connection Parameter is: jdbc:oracle:thin:@<HostName>:1521:<SID>

Where SID is the database name which we are going to access and host name is the IP

address

File--JDBC

Look at this to configure JDBC Sender

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...

One suggestion -

You can use either Oracle 8 or Oracle 9 or Oracle 10g.

But be specific on choosing the drivers

Oracle 8i/9i=> OJDBC14.jar

Oracle10g=>OJDBC14_g.jar for configuring in Visual Admin.