Hvantage Pentaho Community Edition @AWS Platform

Frequently Asked Questions: FAQ

1] How to use the Pentaho BI instance?

If you want to use 'Pentaho BI Instance,' visit the AWS Market Place and look for Pragmatic Pentaho Business Intelligence Page. Once you get the page, launch the BI instance.

2] How can I gain access to my Pentaho BI?

If you want to access your Pentaho BI, the following steps will help you:.

• Open the browser
• Enter the IP address of the 'AWS Instance' and access 'Pentaho BI Instance' for the first time and wait till the instance gets created.
• From the subsequent times, you can gain access to Pentaho BI Instance by accessing Instance_IP:8080.

3] How will I know if the Pragmatic BI Pentaho is ready?

Our instance comes with preconfigured and production-ready environment. You will find the essentials preinstalled and configured.

4] What are the charges of using this solution?

Our Pentaho BI solution is free of cost, and you don't need to pay anything for using it in the Cloud. Apart from the costs involved in hosting AWS, no other charges are applicable.

5] Are my data sets secured on the Cloud?

AWS ensures optimum data security and efficient storage. The presence of Amazon's EBS encryption ensures complete security and seamless support for data sets. Motion security also exists between EBS volumes and EC2 instances. You can also monitor and track access to these EBS volumes, as Amazon's dynamic and flexible access control systems help you that. With perfect encryption and strong access control, you can develop effective security strategies for critical data sets. You can also leverage the dynamic EC2 firewall to restrict access to your data and database.

6] Is this particular installation equipped with the required Pentaho modules, which are essential for my company?

Our 'Pentaho BI Instance' comprises of the vanilla instance possessed by Pentaho 5.4 C.E BI server. You will also gain access to additional powerful BI plugins which are configurable according to your needs. However, you can use them once the BI server gets installed.

7] Which version of Pentaho BI will I get?

We offer the Community Edition of Pentaho BI 5.4.

8] Do I get customization and implementation support from you?

Yes, we offer customization and implementation services to clients. You can visit http://www.hvantage.co.in/services/business-intelligence/pentaho.html and get the details.

9] What are the procedures to change the password after logging in the server?

Follow these steps, if you want to change the user password:

• Login to Pentaho BI server at http://ip:8080
• After this step, visit the Home tab
• Click and select the Administrator Menu
• Click on Users & Roles>Manage Users
• Select the Username, click on the Edit option, and then change the existing password

These steps will lead you to a successful password change process.

10] What to do if even after changing the admin password, I find that it isn't working?

Refresh the Pentaho BI page. Such issues might occur if the changes incorporated by you fails to affect concerned files. Refreshing the page will solve the issue.

11] The instance seems to be running, but this is how my BI page looks like:

Check http://hvantage.co.in/contact.html, as this is the default page for welcoming users. You can wait as this page will redirect you to the Pentaho BI instance running on 'INSTANCE_IP:8080'. Wait for 4 to 5 minutes, and your Pentaho BI instance will get launched by then. If this screen stays even after 5 minutes, stop and restart your instance. Steer clear of rebooting as that might lead to other issues. For more information and technical support, visit support@hvantage.co.in

12] What to do when I can ping the public IP, but nothing is showing up in the browser?

The issue might be concerning security groups. Change your security group permission settings from outbound to inbound according to instructions. You can also use the EC2 Instance through Open22, although we don't recommend it for security purposes. 13] What is the default password and username?

13] What is the default password and username?

The default password is: AWS Instance ID
The default Username is: admin/Admin

14] Even though the Instance is working, the Pentaho page is displaying a Tomcat error. What should I do?

Such issues arise while loading the Instance. Either it isn't fully loaded, or there are certain issues in the process. You can wait for 3 to 4 minutes, stop the Instance, and restart it if the screen still shows up. It is better not to reboot. Visit http://www.hvantage.co.in/contact.html for technical support and assistance.

We've launched a telephonic and Email Helpdesk support for Pentaho BI for both Technical and Functional/User areas. Please note that this is not an alternative to OPW Publishers warranty provided by Pentaho BI. It is meant to solve practical issues faced by companies while configuring and using Pentaho BI. This support involves helping potentially companies who are using Pentaho BI and need someone whom they can call and get help with their running systems.

Hvantage Advantage

• Pentaho BI Experts with in-depth understanding of technical and functional aspects of Pentaho BI
• Experience staff involved in large Pentaho BI implementations spanning over 6-10 months
• In depth understanding of Pentaho BI server Setup, Configuration, Customization, Module migration, Data Migration ETL and advanced reporting Business Intelligence tools

Our Helpdesk support is based on Ticket basis. Each ticket is an issue which could be solved in 1 hour of time or less. Currently we are supporting Europe, Africa, Moddle-East and Asia Pacific You can reach us at E-mail sales@hvantage.co.in or skype us: hvantage

Our plans are as follows:

Features	Premium	Standard	Enterprise
Support limit	8 tickets every month	5 tickets every month	Requirements Analysis Unlimited functional assistance
Availability	5X8	5X8	7AM - 7PM CET Time 7AM - 1PM EST Time
Contact Means	Voice Email	Email	Voice Email
Turnaround time	Reaction time: 4 hours Issue Resolution time: 3 day	Reaction time: 1 day Issue Resolution time: 5 days	Immediately
Pricing	Skype us: hvantage Email:	Skype us: hvantage Email:	Skype us: hvantage Email:

---

User Guide

Hvantage Advantage

Lanuch your Pentaho Community Edition instance with Pragmatic AMI.To get to the Pragmtic pentaho AMI on your instance a link is provided on the landing page. Once the AMI is launched the Pentaho BI server is ready to run your reports and analysis. For you to get the reports/ dashboards on the cloud it's now just a two step process!!

• Pentaho BI server from Hvantage AMI.
• Upload and run the Reports/ Analysis (PRD) to BI server.

Features

Launch your instance with Pragmatic Pentaho BI AMI and start using it as soon as your instance is ready. Its Free!!!! Hvantage Pentaho BI is a free instance to be used in cloud. No charges are applied for it's use. Only cost use have to bare is AWS hosting cost.

• Easy To Get started
• 3-2-1 Launch
• No technical knowledge required for a full cycle installation
• Ready To Use

Hvantage Pentaho BI comes with preconfigured and production ready Pentaho BI platform on it. http://hvantage.co.in/products/other-products/pragmatic-odoo-openerp-amazon-aws-platform.html#Pentaho BI can be referred for more details on BI platform. You can start using it for your organization as soon as your instance is ready and running.

System Requirements

• Ubuntu 14.04 LTS
• Apache 2.4
• JDK 7.0
• Python 2.7.3

Usage

Endpoint

Port 80 and 8080 need to open to access this service, user can see the welcome page when he/she will open their instance IP in browser (unless there is already an DNS assigned to your Public IP). (e.g. http://${public_hostname}/) after pentaho get launch which takes around 5min then they will be redirected to the pentaho URL. (e.g http://${public_hostname}:8080) Endpoint to access Pentaho is : http://${public_hostname}:8080

DEFAULT USERNAMES AND PASSWORDS

Account	Pentaho BI  5.4
Administrator Login:	user: Admin passwd: YOUR_INSTANCE_ID
Business User:	user: Suzy passwd: YOUR_INSTANCE_ID

Tip:-YOUR_INSTANCE_ID Represents the Instance ID that may look like i-db3dc8f8.
**Your public DNS is available on your EC2 page.

TROUBLESHOOTING

Tip 1:Initializing : Pentaho will spend about 2 Minutes to initialize at first boot. Please wait incase you view the screen with message "Service unavailable" on your browser.
Tip 2: Pentaho Upgrade
There are many variants of Pentaho BI CE. Whence you are planning for upgrade its recommended to backup your data from the existing server and commit the upgrade, then restore data to new server.
http://infocenter.hvantage.com/help/index.jsp?topic=%2Fadmin_guide%2Ftask_import_export_repository.html

For all Technical/ Functional Support feel free to contact sales@hvantage.co.in

You can also find about our Support Services and details at http://hvantage.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#Support

You can find more information about this product at: http://hvantage.co.in/

For questions related to deployment/ usage/ functionality of Pragmatic Pentaho BI AMI, please visit: http://help.openerp.com/questions/

---

Hvantage Pentaho AMI 3-2-1 Launch:

Introduction

AMI is the acronym for Amazon Machine Image. An AMI contains all the information necessary to start up and run the software in the image.

AMIs are preconfigured and ready to launch in 3-2-1 countdown pattern. An Amazon Machine Image (AMI) is an encrypted machine image of a specific computer running an operating system that is configured in a specific way and that can also contain a set of applications and services for accomplishing a specific purpose. Note: To cancel your subscription after launch, you first have to terminate all instances running from it.

3-2-1 Launch of Pragmatic Pentaho AMI

You can subscribe to Hvantage AMI from AWS Marketplace product and launch an instance from the Hvantage - Pentaho AMI using the Amazon EC2 launch wizard, in 3-2-1 easy steps.

To launch an instance from the AWS Marketplace using the launch wizard

• Open the Amazon EC2 console at //console.aws.amazon.com/ec2/.
• From the Amazon EC2 dashboard, click Launch Instance.

• On the Choose an Amazon Machine Image (AMI) page, select the AWS Marketplace category on the left. Find the Pragmatic Pentaho AMI by browsing the categories, or using the search functionality. Click Select to choose your product.

• A dialog displays an overview of the Pragmatic Pentaho AMI. You can view the pricing information, as well as all other information that the we have provided. When you're ready, click Continue. Note: You are not charged by Amazon for using the product until you have launched an instance with the AMI. Take note of the pricing for each supported instance type, as you will be prompted to select an instance type on the next page of the wizard.
• On the Choose an Instance Type page, select the hardware configuration and size of the instance to launch, Pragmatic has given preferred HW requirements. When you're done, click Next: Configure Instance Details.

• On the next pages of the wizard, you can configure your instance, add storage, and add tags. For more information about the different options you can configure. Click Next until you reach the Configure Security Group page.

• The wizard creates a new security group according to the specifications for the Pragmatic Pentaho. The security group may include rules that allow all IP addresses (0.0.0.0/0) access on SSH (port 22) on Linux. We recommend that you adjust these rules to allow only a specific address or range of addresses to access your Pentaho instance over those ports.
• When you are ready, click Review and Launch.
• On the Review Instance Launch page, check the details of the AMI from which you're about to launch the instance, as well as the other configuration details you set up in the wizard. When you're ready, click Launch to choose or create a key pair, and launch your instance.

• The instance may take a few minutes or more to launch. You are first subscribed to the product that is launched before your instance can start. If there are any problems with your credit card details, you will be asked to update your account details. When the launch confirmation page displays, click View Instances to go to the Instances page.
  Note: You are charged the subscription price as long as your instance is running, even if it is idle. If your instance is stopped, you may still be charged for storage.
• When your instance is in the running state, you can connect to it. To do this, launch your EC2 public IP/Public DNS:8080 to Connect. Now you are ready with your Pragmatic Pentaho.