| Description |
1 online resource (462 pages) |
| Contents |
Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Working with Databases -- Introduction -- Connecting to a database -- Getting data from a database -- Getting data from a database by providing parameters -- Getting data from a database by running a query built at runtime -- Inserting or updating rows in a table -- Inserting new rows where a simple primary key has to be generated -- Inserting new rows where the primary key has to be generated based on stored values |
|
Deleting data from a tableCreating or altering a database table from PDI (design time) -- Creating or altering a database table from PDI (runtime) -- Inserting, deleting, or updating a table depending on a field -- Changing the database connection at runtime -- Loading a parent-child table -- Building SQL queries via database metadata -- Performing repetitive database design tasks from PDI -- Chapter 2: Reading and Writing Files -- Introduction -- Reading a simple file -- Reading several files at the same time -- Reading semi-structured files |
|
Reading files having one field per rowReading files with some fields occupying two or more rows -- Writing a simple file -- Writing a semi-structured file -- Providing the name of a file (for reading or writing) dynamically -- Using the name of a file (or part of it) as a field -- Reading an Excel file -- Getting the value of specific cells in an Excel file -- Writing an Excel file with several sheets -- Writing an Excel file with a dynamic number of sheets -- Reading data from an AWS S3 Instance -- Chapter 3: Working with Big Data and Cloud Sources |
|
IntroductionLoading data into Salesforce.com -- Getting data from Salesforce.com -- Loading data into Hadoop -- Getting data from Hadoop -- Loading data into HBase -- Getting data from HBase -- Loading data into MongoDB -- Getting data from MongoDB -- Chapter 4: Manipulating XML Structures -- Introduction -- Reading simple XML files -- Specifying fields by using Path notation -- Validating well-formed XML files -- Validating an XML file against DTD definitions -- Validating an XML file against an XSD schema -- Generating a simple XML document |
|
Generating complex XML structuresGenerating an HTML page using XML and XSL transformations -- Reading an RSS Feed -- Generating an RSS Feed -- Chapter 5: File Management -- Introduction -- Copying or moving one or more files -- Deleting one or more files -- Getting files from a remote server -- Putting files on a remote server -- Copying or moving a custom list of files -- Deleting a custom list of files -- Comparing files and folders -- Working with ZIP files -- Encrypting and decrypting files -- Chapter 6: Looking for Data -- Introduction |
| Summary |
Pentaho Data Integration Cookbook Second Edition is written in a cookbook format, presenting examples in the style of recipes. This allows you to go directly to your topic of interest, or follow topics throughout a chapter to gain a thorough in-depth knowledge. Pentaho Data Integration Cookbook Second Edition is designed for developers who are familiar with the basics of Kettle but who wish to move up to the next level. It is also aimed at advanced users that want to learn how to use the new features of PDI as well as and best practices for working with Kettle |
| Bibliography |
Includes bibliographical references and index |
| Notes |
English |
|
Online resource; title from PDF title page (EBSCO, viewed July 10, 2017) |
| Subject |
Data warehousing.
|
|
Database management -- Computer programs.
|
|
Open source software.
|
|
Data structures (Computer science)
|
|
Data integration (Computer science)
|
|
Database Management Systems
|
|
COMPUTERS -- Databases -- Data Warehousing.
|
|
Data integration (Computer science)
|
|
Data structures (Computer science)
|
|
Data warehousing
|
|
Database management -- Computer programs
|
|
Open source software
|
| Form |
Electronic book
|
| Author |
Pulvirenti, Adrián Sergio, author
|
|
Roldá, María Carina, author
|
| ISBN |
9781783280681 |
|
1783280689 |
|
