In this post I will try to explain how to connect OSB to Oracle Database with out using DB adapter. With Weblogic datasource we can directly execute the SQL select queries. We will first create weblogic datasource. Below are the steps to create Weblogic DataSource: Login into Weblogic console. eg. http://localhost:7777/console Go to Services->Data Sources Click on new generic datasources Give Data source name, JNDI name, Database Type. 4. Click next 5. Select Oracle Driver and click next. 6. Give database connection details ie. ServiceName, IP, Schema, Password, port. 7. Click Next, and click Test Configuration. If everything is okay then you will see " Connection test succeeded ." message. Click on Finish 8. Next Click on Data Source 'OSBDB' and click on Targets. Select admin server and click save. You have a data source ready to use. Next, We will show how to us...