CloverETL - MS SQL Server 2012

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

mrhong13371
Posts: 6
Joined: Wed Nov 09, 2016 3:08 pm

CloverETL - MS SQL Server 2012

Postby mrhong13371 » Wed Nov 09, 2016 3:43 pm

Hey folks,

I am trying to establish a connection between CloverETL and MS SQL 2012 using integrated JDBC driver. I used JDBC driver for MS SQL Server 08 -12. Unfortunately I can not access the SQL server, since it only accepts Windows auth. logins. My windows credentials have full admin rights on the server. I also tried to create a local SQL user "clover" on the server. I know that the JDBC URL used is correct, since I can view the failed login attempts in SQL server log which also tells me that only windows authentication is allowed.

The next thing I tried is to setup a connection via ODBC. Therefore I created a User DSN OBDC driver SQL Server (Version 6.03.9600.17415) and OBDC Driver 13 for SQL server. I followed the documentation (http://doc.cloveretl.com/documentation/ ... izard.html) and tried to connect via Generic ODBC (JDBC specific: Generic ODBC and MS SQL Server 08 12) with ODBC URL jdbc:odbc:[Name of User DSN]; which result in error message:

Cannot create JDBC driver 'Generic ODBC'. Cannot find class.
Class with the specified name cannot be found: sun.jdbc.odbc.JdbcOdbcDriver

I googled this and saw that JDBC-ODBC bridge has been removed in Java 8. Java on the machine is 1.7.0_80. So I assume this wouldn't be the problem?
I would be very thankful if someone could help me out here! Also I want to avoid changing SQL server to mixed mode. So I want to connect via Windows Authentication.

Thanks in advance!

imriskal
Posts: 397
Joined: Wed Aug 15, 2012 8:18 am

Re: CloverETL - MS SQL Server 2012

Postby imriskal » Fri Nov 11, 2016 3:11 pm

Hi,

Do I understand it correctly that you are working with CloverETL Designer (not CloverETL Server) and you want to read data from the MS SQL database? If so, you don't have to use ODBC or a separate account, you can indeed use your Windows authentication.

See Windows Authentication on Microsoft SQL Server page in our documentation.
---
Lubos Imriska
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

mrhong13371
Posts: 6
Joined: Wed Nov 09, 2016 3:08 pm

Re: CloverETL - MS SQL Server 2012

Postby mrhong13371 » Tue Nov 15, 2016 4:14 pm

imriskal wrote:Hi,

Do I understand it correctly that you are working with CloverETL Designer (not CloverETL Server) and you want to read data from the MS SQL database? If so, you don't have to use ODBC or a separate account, you can indeed use your Windows authentication.

See Windows Authentication on Microsoft SQL Server page in our documentation.


Hi thanks for your reply. Indeed I am using CloverETL Designer and not server version. And yes we want to read data from MS SQL DB. We were able to solve this issue by updating Java version on server to 1.8 and enabling Windows Authentication mode by installing ntlmauth.dll file to windows system variables path.

Thanks!