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

Last updated on MAY 22, 2023

Applies to:

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

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.

While creating EDS changed the typs as MS SQL Server.

	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

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