jdbc connectors

[Former Member]

What is the importance of jdbc connectors? can please mention some of them with detailed information?

[Former Member]

Thanks for your help

[former_member556603]

Hello Ram,

JDBC Connector

Use

Sun's JDBC (Java Database Connectivity) is the standard Java API for Relational Database Management Systems (RDBMS). The BI JDBC Connector allows you to connect applications built with the BI Java SDK to over 170 JDBC drivers, supporting data sources such as Teradata, Oracle, Microsoft SQL Server, Microsoft Access, DB2, Microsoft Excel, and text files such as CSV. This connector is fully compliant with the J2EE Connector Architecture (JCA) and may be deployed into SAP's J2EE Server.

You can also use the BI JDBC Connector to make these data sources available in BW, via BW's UD Connect.

Integration

The connector adds the following functionality to existing JDBC drivers:

· Uniform connection management that integrates with user management in SAP's Enterprise Portal

· Uniform metadata service, by implementing JMI capabilities based on CWM

· Query model independent of SQL dialect of the underlying data source

The JDBC Connector implements the BI Java SDK's IBIRelational interface.

See also:

· For deployment and configuration information, refer to the howto.html file located inside of the resource adapter archive

· For information about the BI Java SDK and its connection architecture, refer to the index.html file inside of the SDK distribution package

· For more information about Sun's J2EE Connector Architecture, see http://java.sun.com/j2ee/connector/

· For more information about Sun’s JDBC, see http://java.sun.com/products/jdbc/

Using the JDBC Connector

The JDBC adapter for the SAP Enterprise Portal 6.0 is a connector framework implementation based on JDBC.

There are two basic ways to get a connection using the JDBC Connector:

● Via the Connector Service—this approach being faster, simpler, and benefits from the portal’s user mapping from the system

● Direct connection using the J2EE JNDI

Connecting via the Connector Service

Go through this links,

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar

Reward if it is usefulll

[vijay_b4]

Hi Ramakrishna,

JDBC component is a resource adapter based on the Java Database Connectivity (JDBC) standard to enable you to connect to databases. It provides functions for creating and managing DataSource objects, as well as database connection pooling.

Reward points if this helps....

Regards

Vani.

[Former Member]

Hi,

Check this

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

Reward Points If Helpful

Regards

Seshagiri

[Former Member]

Hi,

check the following link for more details:

http://help.sap.com/saphelp_nw04/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm