Kettle resource pool The points to be aware of using SQL Server database

Kettle Open Source ETL tool has its own metadata storage method, can be divided into two kinds of

1:file

2:db

File storage I'm not going to say much here, let's talk about the problem of using SQLserver2008 R2 as a repository in the process of creation

Kettle version:6.0.1

SQL Server Version:2008r2

Here's the point:

1: The data type error is reported when creating the repository, and some of the information created will appear to be unsuccessful. But don't worry about it this time.

There are some problems with the script that created the repository

CREATE TABLEr_version (id_versionBIGINT PRIMARY KEY, Major_versionINT, Minor_versionINT, Upgrade_dateDATETIME, Is_upgradeBIT);INSERT  intoR_version (Id_version, Major_version, Minor_version, Upgrade_date, Is_upgrade)VALUES(1,5,0,'2016/06/20 21:03:16.689','N');CREATE TABLER_user (Id_userBIGINT PRIMARY KEY, LOGINVARCHAR(255), PASSWORDVARCHAR(255), NAMEVARCHAR(255), DESCRIPTIONVARCHAR(255), ENABLEDBIT);INSERT  intoR_user (Id_user, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED)VALUES(1,'Admin','2be98afc86aa7f2e4cb79ce71da9fa6d4','Administrator','User Manager','Y');INSERT  intoR_user (Id_user, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED)VALUES(2,'Guest','2be98afc86aa7f2e4cb79ce77cb97bcce','Guest Account','Read-only Guest Account','Y');

Solution to the problem:

1: Delete the original db

2: New DB in Database

3: Modify the above SQL script bit type to char (2), and then in the Create window execution or copy SQL manually execute the Create repository script, recommend the first, directly in the SQL window to modify

Ps:kettle Connect to Oracle The database name is the name of the SID Oh, not the name in TNS or the name of servername.

Kettle resource pool The points to be aware of using SQL Server database