Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Pentaho 3.2 Data Integration: Beginner's Guide

You're reading from  Pentaho 3.2 Data Integration: Beginner's Guide

Product type Book
Published in Apr 2010
Publisher Packt
ISBN-13 9781847199546
Pages 492 pages
Edition 1st Edition
Languages

Table of Contents (27) Chapters

Pentaho 3.2 Data Integration Beginner's Guide
Credits
Foreword
The Kettle Project
About the Author
About the Reviewers
Preface
Getting Started with Pentaho Data Integration Getting Started with Transformations Basic Data Manipulation Controlling the Flow of Data Transforming Your Data with JavaScript Code and the JavaScript Step Transforming the Row Set Validating Data and Handling Errors Working with Databases Performing Advanced Operations with Databases Creating Basic Task Flows Creating Advanced Transformations and Jobs Developing and Implementing a Simple Datamart Taking it Further Working with Repositories Pan and Kitchen: Launching Transformations and Jobs from the Command Line Quick Reference: Steps and Job Entries Spoon Shortcuts Introducing PDI 4 Features Pop Quiz Answers Index

Time for action – installing MySQL on Windows


In order to install MySQL on your Windows system, please follow these instructions:

  1. Open an internet browser and type http://dev.mysql.com/downloads/mysql/.

  2. Select the Microsoft Windows platform and download the mysql-essential package that matches your system: 32-bit or 64-bit.

  3. Double-click the downloaded file. A wizard will guide you through the process.

  4. When asked about the setup type, select Typical.

  5. Several screens follow. When the wizard is complete you'll have the option to configure the server. Check Configure the MySQL Server now and click Finish.

  6. A new wizard will be launched that lets you configure the server.

  7. When asked about the configuration type, select Standard Configuration.

  8. When prompted, set the Windows options as shown in the next screenshot:

  9. When prompted for the security options, provide a password for the root user.You'll have to retype the password.

    Tip

    Provide a password that you can remember. You'll need it later to connect to the MySQL server.

  10. In the next window click on Execute to proceed with the configuration. When the configuration is done, you'll see this:

  11. Click on Finish. After installing MySQL it is recommended that you install the GUI tools for administering and querying the database.

  12. Open an Internet browser and type http://dev.mysql.com/downloads/gui-tools/.

  13. Look for the Windows downloads and download the Windows (x86) package.

  14. Double-click the downloaded file. A wizard will guide you through the process.

  15. When asked about the setup type, select Complete.

  16. Several screens follow. Just follow the wizard instructions.

  17. When the wizard ends, you'll have the GUI tools added to the MySQL menu.

What just happened?

You downloaded and installed MySQL on your Windows system. You also installed MySQL GUI tools, a software package that includes an administrator and a query browser utility and that will make your life easier when working with the database.

You have been reading a chapter from
Pentaho 3.2 Data Integration: Beginner's Guide
Published in: Apr 2010 Publisher: Packt ISBN-13: 9781847199546
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}