Etl tool, kettle implementation loop, etl Tool kettle implementation
Kettle is an open-source ETL Tool written in java. It can be run on Windows, Linux, and Unix. It does not need to be installed green, and data extraction is efficient and stable.
Business Model: there is a large data storage table in the relational database, which is designed as a parity datab
This article describes how to synchronize PostgreSQL data to Fusioninsight LibrA via the ODI 12c.1. fusioninsight Libra Client ConfigurationConfigure the Fusioninsight Libra client on the ODI service to complete the client authentication operation.[[emailprotected] ~]$ source /u02/huawei/client/bigdata_env [[emailprotected] ~]$ kinit candonPassword for [emailprotected]: [[emailprotected] ~]$ klist Ticket ca
The new version of ODI is released to better support the Big Data Platform on the current market.Big Data geneticsWithout changing the efficiency of Odi, Odi has added more and more data source integration capabilities. ODI is a standard E-LT tool on the Oracle platform and, in fact, a data integration tool for Oracle
For the Data warehouse and ETL knowledge, I am basically a layman. Everything has to start from scratch, take a note, to facilitate the understanding of learning progress.First, let's take a look at the basic definition:Well, some people also called the ETL simple data extraction. At least before the study, the leader told me that you need to do a data extraction tool.In fact, extraction is the key part of
is through the mining of logs (Oracle's log miner and IBM db2/400). But the ODI CDC must require the source table to have a primary key.second, the problem of deleting data introducedWhen we start using ODI for data synchronization in CDC mode, everything is OK, and the deleted data can be correctly synchronized to the target database. Then, becauseBusiness requirements, we only need to synchronize some of
During database management, extraction, conversion, and loading (ETL, extract, transform, and load) are three independent functions that constitute a simple editing task. First, read the data in the specified source database and extract the required sub-dataset. Then, the conversion function uses rules or drop-down lists to process the acquired data or create connections with other data, so that it can be converted to the desired state. Finally, we us
Note: At the request of the general public, see the address for the original image:Http://blog.csdn.net/meteorlwj/article/details/6949096
Prerequisites:1) install Oracle ODI2) install Oracle Xe Database3) create database users odi/apps, odi_work/apps, odi_ess/apps, odi_obj/apps4) Create a database table cux_users/cux_sites in odi_ess and odi_obj (where the source and target data are stored ).Table creation script:Create Table cux_users(User_id number,
Reprinted ETL architect interview questions
1. What is a logical data mapping and what does it mean to the ETL team?
What is Logical Data ing? What role does it play on the ETL project team?
A:
Logical Data Map) describes the data definition of the source system, the model of the target data warehouse, and instructions on operations and processing methods to conv
:
The agent is a Java component component, which is also divided into physical agents and logical agents, usually it needs to run on the target library (also can run on the non-target library), the role is to dispatch the data migration job, usually, it simply retrieves the code from the execution repository and requests the database server, The operating system or script engine executes the code.
Data base:
Contains the master repository and its affiliated work repositori
This article focuses on creating a project using groovy in ODI and adding a mapping for a table transformation. To create a Groovy script, you can open an edit window from the ODI Studio menu: Tool->groovy-> new script. Before executing the script below, verify that there is already an EMP table in the model. UsersrcUserdest import oracle.odi.domain.project.OdiProject Import Oracle.odi.domain.project.find
The formal environment is installed in the runtime, so only the relevant information and scenarios for the master repository can be imported into the formal environment
Synchronizing database table Structures
Data repository synchronization (only once, not required later, unless topology is modified)
Build the scenario after you have tested the ODI interface in the development environment
Then the development environment of the scene in
This article describes how to use simple CDC for Oracle ODI 12c. It is the simplest kind of CDC. In this mode, each CDC table change is captured independently, and there is no need to consider data consistency between multiple tables with primary foreign key reference relationships.1. Import Knowledge ModulePrior to this, all the knowledge modules have been imported, and the CDC feature knowledge module as shown:2. Set the model CDC parameterOpen the
1.1.1. What is a database?
The ODI database can be installed in any database that supports ansi iso 89. There are two types of databases:
1. master repository: stores the topology of all IT resources of an enterprise, and saves the Security Information and version information of the project and data model for the ODI graphics module. You can create one. Master repository should be stored as independent a
The ODI incremental refresh, after modifying the primary key value, causes the refresh to fail. Workaround: Use columns with fixed values in the table as the basis column for incremental refreshes.The demo is as follows:As above, the source and target tables have the same records. The source table primary key information is now modifiedAfter performing a data synchronization refresh, the target table data is as followsfound that when the source table
There is no major change relative to 10 Gb. Unlike owb, an interface has many components available. It can only be simple from source to target. Complex conversions require nesting of interfaces. For certain database features, you need to write km. The package process control function is not strong. For example, loop operations can only be completed in procedure. Procedure and km are basically coding.
Therefore, the role of ODI is limited to the inte
1. To add an ODI driver to ODI11G, copy the data jdbc driver to the following two locations: $ HOME (usually in the windows system folder, for example, C: UsersAdministratorAppDataRoamingodioracledi ). odioraclediuserlib ----- used for statio data integration; ODI_HOMEoraclediagentdrivers ----
1. To add an ODI driver to ODI11G, copy the data jdbc driver to the following two locations: $ HOME (usually in the
source ETL tool. Open source of course free, some things free of charge is not very convenient.
Download Address: http://kettle.pentaho.com/
---------------------------------------
4. ODI
Reviews: Oracle database vendors provide tools that have limitations and are too deeply coupled with Oracle databases.
Download Address: www.oracle.com/technetwork/cn/testcontent/index-091026-zhs.html
----------
Configuring the Domain for the Java EE agent creates a database SchemaBefore configuring the Java EE agent, you must ensure that the appropriate scheme is created in the data. Repository Creation Utility created the warehouse automatically when it was created. Refer to Using Repository Creation utility to create the archive and connectTwo start the Fusion Middleware Configuration Wizard to create a new domainEnter oracle_home/oracle_common/common/binsuch as D:\Oracle\Middleware\Oracle_Home\orac
Creation and configuration of the ODI studio topology (Oracle)Like the creation and configuration of the ODI studio topology (MySQL), MySQL is only turned into Oracle, considering that the ODI has more knowledge modules about Oracle.I. Conceptual interpretationTopology Manager is primarily used to manage the following 5 categories of tasks and store the informati
Before entering Odi, you must first create a database user. Each user must be created for the primary and working databases. The following script is used:Create tablespace d_odi_data datafile 'C:/Oracle/DB/product/10.2.0/oradata/hyporcl/d01_odi_data 'size 300 m reuse autoextend off;
Create user ODI identified by ODI default tablespace d_odi_data;Grant connect, re
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.