Pentaho data integration csv file to xml with xsd software#
The software allows connections with the main databases: Oracle, SQL Server, MySQL, PosrgreSQL, Firebird, IBM DB2, and others. Select one of the two options and click on Ok.Ĭlick on new to configure a new connection with the server Tools-> Repository -> Connect to repository Whether the initial screen will not open, follow these steps to access it: There are two ways to configure your repositoryġst Store transformations and jobs inside databaseĢnd Define a folder and use it as a repository This action will store jobs and transformations on a local machine. In cases where the specification of the path is not the focus, close the window. The connection with repository allows the saving of transformations and jobs in a preferable place. When PDI opens, the screen to configure repository is presented. Run spoon.bat (Windows) or spoon.sh (Linux).Installation and ConfigurationĬurrently, the latest stable version is 5.4.0.1-130. Therefore, a step-by-step approach is used, with print screens and an easy language. Exportation of data from database to filesĪt this chapter we focus on the creation of a project on PDI. Migration of data between applications and databases. Nevertheless, it can be focused on the following aspects: Since it is an ETL tool, its functionalities are generally focused on data warehouse development. It can be used as an independent application or as a part of Pentaho Suite. Pentaho Data Integration (PDI/Kettle) is a tool to integrate data, responsible for extract, transform and load processes (ETL).
0 kommentar(er)
