INSTALLATION DOCUMENTS BY RAVI

Tuesday, July 23, 2019

Connecting Microsoft SQL Server using Oracle SQL developer


We can connect Microsoft SQL server using oracle SQL developer by following the steps below.



Download “jTDS-SQL Server and Sybase JDBC driver”.





















Open SQL developer



















Click on Tools and then click on Preferences



















Under Database Click on Third Party JDBC Driver



















Add the downloaded SQL server JDBC driver and click on ok


















Try to create a new connection, we will see SQL Server option now.

Select SQL Server and provide the connection details and Click on Test.
We will get a Success status.
























1 comment:


  1. تعد الاول افضل شركة غسيل خزانات بالمدينة المنورة تعمل على استخدام افضل ادوات تنظيف وتعقيم خزانات المياه

    ReplyDelete

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...