Kettle_ using the Repository function to store KTR metadata in the database uniformly

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/46117065

Target

Use the library function in Kettle to store ktr files uniformly in the database for local version management

KTR: Conversion using kettle editing, known as KTR;

conversion: Add a function module, the project to implement ETL is called transformation.

Once you've determined, click OK to complete the repository creation as follows:

Once created, an advanced resource library looks at the effect, such as:

You can set up and create a directory for the repository as follows:

Below, add a ktrto the repository as follows:

Design a ktr scheme, then save, click OK, as follows:

After saving ktr to the repository, go inside to see if it's saved, as follows:

As you can see, the conversion named "Deep Blue ktr1" has been saved in the Bjbank repository, as follows:

Summary

Using the "Resource Library" in Kettle , the metadata is stored uniformly in the database, which is beneficial to the unified management and change of the ktr of the library.

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/46117065

Series Link _20150523:

the growth of Blue-chase DBA (1): Rushing to the road and into Shandong  

Blue Growth Kee-Chase DBA (2): Install! Installation! A long-lost memory that caused me to re-perceive the DBA

the growth of Blue-Chase DBA (3): antique operation, data import and export become a problem  

the growth of Blue-Chase DBA (4): Recalling the youth, and then explore Oracle installation (Linux 10g, 11g)  

The growth of Blue-Chase DBA (5): No talking about business, annoying application system

The growth of Blue-Chase DBA (6): Work and life: small skills, great people

The growth of Blue-Chase DBA (7): Basic Command, foundation stone

The growth of Blue-chase DBA (8): Regain SP report, recall Oracle's Statspack experiment

The growth of Blue -Chase DBA (9): National Day, chasing DBA, new plan, new departure

the growth of the Blue-Chase DBA (10): flying knives to defend themselves, not expertise: fiddling with middleware WebSphere  

the growth of Blue-chase DBA (11): The ease of coming home, the dizzy wake up  

The growth of Blue-chase DBA (12): Seven days seven harvested SQL

Blue. Growing up-chasing DBAs (13): Coordinating hardware vendors, six stories: what you see and feel "servers, storage, switches ..."

the growth of Blue-chase DBA (14): An unforgettable "cloud" side, starting Hadoop deployment

the growth of blue-chasing DBAs: Think FTP is very "simple", who Chengxiang twists

The growth of Blue-Chase DBA: The DBA also drank and was 捭阖

Series Link _20150528:

Soccer and Oracle Series (1): 32 Way Princes soldiers of, Oracle32 Process Alliance Group A bigger picture of the Brazilian Smon process

Soccer and Oracle Series (2): Brazil opener Preview, Oracle architecture Talk

Soccer and Oracle Series (3): Oracle process ranking, World Cup round is about to be fought!

Soccer with Oracle Series (4): From Brazil fiasco in Germany, think of the difference in RAC topology comparison!  

Soccer and Oracle Series (5): Fifa14 game The missing DirectX Library is analogous to the RPM package from Oracle!

Soccer and Oracle Series (6): The Asian Cup with the library--Refueling Chinese team

Kettle_ Store KTR metadata in the database using the Resource library feature