JDBC Scenerio.

[Former Member]

hi guruz,

when we do Configuration steps in Integration Depository for communication channel.(whether file 2 jdbc or jdbc to file).

how can i will know the database connection parameter like

driver name

connection name

user name

password

i am making txt file to jdbc(MS Access db).

i want to update one table in to MS access from txt file data.

how can i know the db connection parameter.

pls help me

warm regards.

[Former Member]

i appericiate yours help

[Former Member]

HI Pawan,

Initially you should get installed the required drivers in your XI server by the basis people.Then get the connection details, user Id and password from them.

Please refer the blog of Jdbc to Jdbc scenario in which MS access db is used.

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

In the same way you can do your scenario(File to Jdbc or Jdbc to file)

I hope this helps you

Regards,

Pradeep

[Former Member]

Dear Pawan:

If you are using MS Access as your Data base, use the following parameters

driver name: sun.jdbc.odbc.JdbcOdbcDriver

connection name jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=G:/----

---

.mdb*

user name If your Data base requires

password

Best Regards

Praveen K

[Former Member]

Hi Praveen ,

thanks very much for ur response ,still i have one doubt ,here how i will know that which table is going to update .In one DB more than one table may be there.

Can i make this db(means .mdb file) on my c drive(like c:\------)

regards.

[Former Member]

Hi

Refer

SAP Network Blog: Connecting to MS Access using receiver JDBC Adapter (Without DSN)

As per these connection parameters you can update the MS access tables. If you have provided the User name and Password for table then that you need to pass in XI.

Thanks

Swarup

[prateek]

See this

Regards,

Prateek

[Former Member]

Refer this Blog for MS connectivity.

Also: the connection parameter, url, driver name are totaly depends on the type of the data base.

driver name and connection url depends on the type of the database.

You can also search "JDBC connection" on google and find more on it.

Thanks

Farooq.