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. تعد الاول افضل شركة غسيل خزانات بالمدينة المنورة تعمل على استخدام افضل ادوات تنظيف وتعقيم خزانات المياه


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...