My Oracle Support Banner

Connecting External Data Source As MS SQL Server In DIH (Doc ID 2605512.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

Issue 1:

 Observed the below error in DIH.log

[25-09-19 01:18:11 AM] ~ INFO ~ DIHLOGGER ~ [DataStoreDAO][getDriver]drivercom.microsoft.sqlserver.jdbc.SQLServerDriver

[25-09-19 01:18:11 AM] ~ INFO ~ DIHLOGGER ~ [DataStoreServiceClient][testConnection]SuperTypTABLE

[25-09-19 01:18:11 AM] ~ ERROR ~ DIHLOGGER ~ [DataStoreServiceClient][testConnection]com.microsoft.sqlserver.jdbc.SQLServerDriver

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:387) ~[weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:348) ~[weblogic.server.merged.jar:12.1.3.0.0]

Issue 2: 

Unable to Create EDD after selecting the EDS. The page is not refreshing it is showing hourglass.

Changes

While creating EDS changed the typs as MS SQL Server.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.