PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Data Transformer - is it a viable tool - connection issue

Is the Data Transformer tool delivered by Enterprise Components with FSCM 9.0  a viable product for a configurable translation of GL Interface Data?

I'm having trouble getting past the Remote Database Access Management - Test Connection test, I keep receiving a "Bad Connection" error followed by

GetConnection failed: java.lang.ClassNotFoundException:
com.microsoft.jdbc.sqlserver.SQLServerDriver
The Appserver failed to set the Java CLASSPATH correctly or the driver class for the 'Microsoft' DB is not found
DataSource ID: 'FSCMSAND'
m_DriverName: 'com.microsoft.jdbc.sqlserver.SQLServerDriver'

I've tried adding in sqljdbc.jar and sqljdbc4.jar  to the AppServer class directory and the Classpath but no progress so far.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center