Problem with DBOutputTable - New User

CloverDX Platform
1

Hi,

I am a new user and I am in a jam. I have a DBOutputTable that inserts data from a reformat. The reformat data has a birthdate defines as date and the MSSQL 2012 database has the birthday as datetime. When I run the graph I get an error message saying that the sql quesry is invalid. The exact message is

WARN [main] - [DBOutputTable:DB_OUTPUT_TABLE0] - Invalid sql query. Incompatible Clover & JDBC field types - field date_of_birth. Clover type: date, sql type: NULL

What am I doing wrong?

I also have a furhter error saying that null cannot be inserted into a field because it does not allow nulls. The field is defined as a unique identifier in MSSQL. The Database Connection Driver I am using is the Microsoft SQL Server driver.

Lastly,

There is a recommendation for using an open source driver called JTDC. I would love to try it out but the buttons are greyed out. Is that because I am running the community version? Can afford $4K for the full version due to my company being a nonprofit.

Thanks for any help! I am in a jam and need answers as soon as I can get them. I am trying to covert data from threee seperate databases for our go live date in two weeks.

Thanks!
Matt

2

Hi, Matt,

I would recommend you to try your INSERT query also right in your database, without any proxy. This way you should see which query is possible to use and which is not.

Please post here also your creation table sql script and all the constraints so we can reproduce your issue.

Regarding another JDBC driver, this option is not possible in Community version, see http://www.cloveretl.com/products/community-edition/features.

Best regards,