How to create Data Source and assign JDBC driver.

[Former Member]

How should I go about creating a data source and assigning a JDBC driver ?

The blog /people/sampath.gunda8/blog/2008/02/21/connecting-an-application-to-an-external-database-in-sap-nw-ce-71 talks about Deploying the JDBC Driver by going to Create New Resource->Deploy New JDBC Driver in the http://<host>:<port>/nwa. But I don't see Deploy New JDBC Driver option under Create New Resource

These are the following list under Create New Resource and then under Resource Type dropdown

JDBC Data Source Alias
JDBC Data Source
JMS Queue
JMS Topic
JMS Connection Factory
JMS Destination Reference
JMS Connection Factory Reference

Thanks

Srinivas

[Former Member]

Hi Srinivas,

Create a Custom JDBC DataSource

Refer to the following article on how to deploy and confirm a jdbc driver as datasource:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40db1ed9-b7c2-2b10-66b8-84f6954b...

Regards,

Kartikaye

[Former Member]

Hi Kartikaye,

Thanks for your response. The config document talks about oracle data source. I am concerned with MS SQL 2005 data source.

Do you have details for the following values, while creating the data source ?

1. Should I select JDBC Version 1.x or 2.0 ?

2. If 1.x , what is the Driver Class value, and how to find out the Database URL ? Also, what user/password should I be using. The DBA set me up as db_owner, so that I can access using my regular login/pwd.

3. If 2.0, what are Object Factory, DataSource Type, and CPDS Class Name values ?

Under Additional tab, can you also give me generally accepted "Connection Pooling" values ?

Regards

Srinivas