We help you significantly to reduce the costs of business intelligence implementation using Pentaho
Our Pentaho Development Services
Andolasoft leverages Pentaho for end-to-end data integration and analytics to offer data integration, analytics and data mining capabilities.
Pentaho has a subscription-based enterprise edition which runs on-premises applications. We employ Kettle which is a free and open source ETL (Extract-Transform-Tool) tool which enables us to gather data from various data sources and then consolidate into a single, unified location.
Pentaho provides powerful analytics capabilities that enable organisations to collect and refine different types of data that promotes more accurate and timely decision-making.
- Pentaho Analysis and Consulting
- Custom Pentaho Solutions
- Pentaho Implementation and Integration
- Pentaho Upgrades and Migrations
- Business Intelligence and Analytics
- ETL development
- Performance Tuning
- Pentaho Support and Maintenance
14+ Years of Customer Satisfaction
- 250+
Customers
- 35+
Countries including USA
- 350+
Solutions Delivered
Why Choose Pentaho BI?
Pentaho is a leading business intelligence tool which makes it possible for organizations to easily access, organize and analyize data thereby enabling businesses to derive useful information to make strategic decision making.
- A comprehensive platform – from data integration to analysis from one vendor
- Cost-effective, with no per user pricing model
- Ease of use
- Self-service reporting and dashboards
- Real-time reporting
- Scalable solution based in J2EE architecture
- Low total cost of ownership (TCO)
- Affordability
- Full function data integration, reporting, and analysis features
- Extreme ease of use and access
- Intuitiveness of the product
Technical Profile of our Pentaho Developers
Pentaho is one of the leading business intelligence platforms in the world. Our developers are well versed with all the different aspects of Pentaho. We have the technical experience and expertise of our dedicated pentaho developers who can help you monetize your ideas.
- JDK
- MySql
- Oracle
- PostgreSQL
- Amazon RDS
- Javascript
- XML
- GIT
- Excel/CSV/xlsx/TXT
- Scheduler (CRON)
- Kitchen
- Spoon
Are you a small or midsize or enterprise business seeking to transform your raw data into significant functional information? Do you need a team of competent Data Warehouse(DWH) developers to help you provide cost-effective business intelligence reports and support?
Expertise of our Pentaho Programmers
- Good knowledge of integrating the ETL tool Pentaho Data Integration - PDI (formerly known as Kettle.)
- Expertise in creating transformations and jobs using the GUI based tool
- Mailing − Users can email a published report to other users
- Expertise in load testing by creating dummy data in the tables using PDI
- Good knowledge in preparing the end to end analytics and reporting
- Data visualization, and custom ETL development End-to-end data integration and analytics at enterprise scale
- Expertise in sending customized reports via emails
- Expertise in data warehousing
- Expertise in data migration
- Create reports using various databases like MySQL and PostgreSQL, Amazon RDS etc
- Job scheduling − Allows users to execute reports at given intervals
- Expertise in creating Tables, Procedures, Functions
- Good knowledge in customizing data using web Technologies, JavaScript, and XML
- Expertise in load data using FTP
- Expertise in creating reports in flat files as well database tables
Our Pentaho Development Process
We begin our Pentaho Development by gathering and understanding your business objectives. After assessing and establishing your business objectives we begin the assembling and designing stage. Then we begin implementing, followed by testing and monitoring.
We work with you at every step of the way thereby empowering you with the business intelligence strategies you need that provide a competitive market advantage.
We help you to develop cost effective BI Solutions
What Our Clients Say
Our Work
Orangescrum Enterprise and Self-hosted
Data Transformations
We automated data imports from various endpoint systems for Orangescrum Enterprise and Self-hosted solutions.
We transformed the Orangescrum enterprise MySQL database by performing various data optimization processes such as combining tables, separate single table to multiple tables, format tables, as well as load it into Orangescrum Self-hosted MySQL database storage systems.
Andolasoft can help you process your data from any source to destination by applying the transformations.
Don't know how to set up Amazon Redshift cluster to connect with Pentaho PDI
Amazon Redshift Cluster Set-up Steps to Connect With Pentaho PDI
Step 1: Registering for AWS and login
First of all, visit Amazon AWS and register into an AWS account.
Step 2: AWS Management Console
This is the home page for AWS and the place where we can view all the product services provided by Amazon.
Step 3: Create a Redshift Cluster
From the AWS Management Console Log into Redshift and click on “Launch Cluster“ to create a Redshift cluster. Provide the cluster’s basic information such as the Database Name, Database Port, Cluster Identifier, Master Password, and Master User Name
Once you are done with the cluster configuration, then provide the information on the Node Configuration page. Decide the suitable number of nodes to store your data.
Step 4: Changing the Security User Group in EC2
Clients cannot connect to the Redshift database if we are not allowing the IP and TCP port accessible to the security group.
To allow the IP and TCP port accessible click on EC2 Dashboard (from the AWS Management Console) and select the Security Group Tab. From the security groups, you need to change the Inbound rule for the security group.
Step 5: Using Pentaho PDI/Kettle to Access Redshift
Accessing Redshift using Kettle is straightforward once you have properly configured the cluster as mentioned above.
In the Redshift Dashboard, move to the “Connect Client” section of the tab and select the drivers. Download the driver as per your requirement and place it in the lib folder.
In the Database Connection section of the Kettle, select Connection Type as: Redshift. Give the Host Name as the cluster hostname (you can find it in the “Connect Client” section of the Redshift dashboard). The rest of the details are same as what we have provided during the cluster configuration step.
Loading Data from S3 to Redshift
Step 1: Creating the Table in Redshift Cluster
First of all, we need to create a table in the redshift cluster. We can either create the table manually by writing the CREATE command in any client tool like SQLWorkbench OR use PDI to generate the SQL and create the table in the Redshift cluster. Here I am using SQL Workbench/j
Assuming we have successfully built up your Amazon Redshift cluster and used Pentaho to connect to the cluster. Now we can try to loading the data using PDI.
We can take a simple Pentaho S3 CSV input and a Table Output step as below:
Step 2: Use S3 CSV input
This is my source data. It’s holding the data which I need to move to the Redshift database.
The dialog box of the S3 CSV input holds:
S3 Bucket: This is the Amazon S3 Bucket Name. You need to enter this in the dialog box in here.
Access Key & Secret Key are defined in C:\Users\username\.aws
Both the Access Key and Secret Key are available in the IAM Security Management console of your AWS account.
Delimiter: This is the delimited character used in CSV file.
Enclosure: This is the character used to enclose CSV file.
Step 3: Use Table Output
This step is designed primarily for loading the data from S3 bucket onto Redshift table.
The dialog box of the S3 CSV input holds:
Connection: Connection name created at step 5.
Target Schema: Click "Browse" to select database schema
Target Table: Click “Browse” to select a table to load data.
Looking to set-up Amazon Redshift Cluster to connect with Pentaho PDI
Frequently Asked Questions
You can use multiple copies of your output step and connect the proceeding step by giving 'Distribute rows' while you connect the hop.
You can use the bulk loading option which contains Vertical Bulk Loader, Oracle Bulk Loader, MySQL Bulk Loader, etc.
No, the default transformation architecture is to run in parallel while jobs run in sequence. Changing this requires an architecture change that might affect the performance.
You can calculate aggregate functions over the whole dataset by leaving this The Fields that make up the Group Table blank in the 'Group By' step.
No, we cannot form a loop inside the same transformation. But we can form a loop between transformation/jobs inside a job
We can execute a prepared SQL join statement directly in the database join step whereas we cannot do that in the regular join
The Call DB Procedure needs to be triggered. Use a Row generator step generating e.g. 1 empty row and link that with a hop to the Call DB Procedure step.
Yes, you can use the 'Get System Info' step in a transformation to get the Pentaho version. In the 'Type' column choose ‘Available Processors’.
Upon every upgrade, Pentaho enhances a step/remove a step/replace a step/add a configuration. Those steps which change from its default configuration is called depreciated steps.
Dashboard metrics can be exported in Excel, CSV, PNG, and PDF.
Database Tables, CSV file, SQL query are the inputs to create data source.
An Open source framework that allows the creation of highly customizable dashboards on top of the Pentaho Business Intelligence server. It’s based on web development standards such as CSS, HTML5 and JavaScript (leveraging some commonly used frameworks like jQuery or Bootstrap).
Pentaho provides flexible API with full documentation to integrate visualizations from third party libraries such as D3 or Fusion Charts.
Standard data source like SQL, MDX, Pentaho Metadata, etc, apart from this it also supports Kettle Transformations on the fly, so there are no limits to where your data comes from or how source data are combined together.
Yes, in Pentaho it’s very easy to translate all resources (User console, Menu, Labels etc., except data being displayed from database) from English to other languages. 13 Translations are available currently; there is also an option to propose a new translation. Pentaho Language pack is applicable to both Community and Enterprise Edition.
- 5432: PostgreSQL Server
- 8080: BA Server Tomcat Web Server Startup Port
- 8012: BA Server Shutdown Port
- 9080: DI Server Port
- 9001: HSQL Server Port
- 9092: Embedded H2 Database
- 50000 or 50006: Monet Database Port
Windows, Android, iPhone / iPad, Mac
Relational Databases, Analytic Databases, NoSQL Databases, Hadoop and other Data Sources such as Files, Business Applications, etc.,
Lots of people in your organization spend time manually producing reports – downloading data into Excel, manipulating it then emailing it out. It’s costly and error prone.
Pentaho Data Integration provides advanced clustering and partitioning capabilities that allow organizations to scale out their data integration deployments.
Data Ingestion, Manipulation and Integration, Enterprise and Ad Hoc Reporting, Data Discovery and Visualization Predictive Analytics.
Pentaho Data Science Pack operationalizes analytical modeling and machine learning while allowing data scientists and developers to unburden the labor of data preparation to Pentaho Data Integration.
It can not be added directly in the Pentaho application. Download the schema file, update it using schema workbench and then publish the schema file.
Central Authentication Service (CAS) and Integrated Windows Authentication (IWA) are supported.
View more