LEADER 05847nam 2200757 450 001 9910453487203321 005 20200520144314.0 010 $a1-78328-068-9 035 $a(CKB)2550000001167970 035 $a(EBL)1389374 035 $a(OCoLC)865330167 035 $a(SSID)ssj0001139950 035 $a(PQKBManifestationID)11740619 035 $a(PQKBTitleCode)TC0001139950 035 $a(PQKBWorkID)11221033 035 $a(PQKB)11469744 035 $a(MiAaPQ)EBC1389374 035 $a(CaSebORM)9781783280674 035 $a(PPN)228049210 035 $a(Au-PeEL)EBL1389374 035 $a(CaPaEBR)ebr10815518 035 $a(CaONFJC)MIL549303 035 $a(EXLCZ)992550000001167970 100 $a20131220d2013 uy| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aPentaho data integration cookbook $eover 100 recipes for building open source ETL solutions with Pentaho data integration /$fAlex Meadows, Adria?n Sergio Pulvirenti, Mari?a Carina Rolda?n 205 $aSecond edition. 210 1$aBirmingham :$cPackt Publishing,$d2013. 215 $a1 online resource (462 p.) 300 $aFirst published, June 2011. 311 $a1-78328-067-0 311 $a1-306-18052-X 320 $aIncludes bibliographical references and index. 327 $a""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"" 327 $a""Deleting data from a table""""Creating 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"" 327 $a""Reading files having one field per row""""Reading 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"" 327 $a""Introduction""""Loading 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"" 327 $a""Generating complex XML structures""""Generating 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"" 327 $a""Looking for values in a database table"" 330 $aPentaho 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. 606 $aData warehousing 606 $aDatabase management$xComputer programs 606 $aOpen source software 606 $aData structures (Computer science) 606 $aData integration (Computer science) 608 $aElectronic books. 615 0$aData warehousing. 615 0$aDatabase management$xComputer programs. 615 0$aOpen source software. 615 0$aData structures (Computer science) 615 0$aData integration (Computer science) 676 $a005.46 700 $aMeadows$b Alex$0980448 701 $aPulvirenti$b Adria?n Sergio$0980449 701 $aRolda?$b Mari?a Carina$0980450 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910453487203321 996 $aPentaho data integration cookbook$92237120 997 $aUNINA