The issue of database connectivity is an age old process in the world of IT. But with Pentaho every such complexities can be overcome.
After installing all the necessary JAR file we need to start our BA server.
1. Start the web application and BA server and then login to the user console. Click on File, go to Manage, click on Data Source. The Data Sources dialog box appears.
– Click the plus icon (+) on the right and select JDBC. The Database Connection dialog box appears.
2. In the following step define your connection name, the host name and other credentials needed to connect your BA server to the Database.