Skip to main content
Pentaho Documentation

Specify Data Connections for BA Design Tools

File:/grBaservStepToolsDataConnections.png

The BA design tools need a way to connect to where you store data, as well as to the BA Server where you publish and share what you create in the design tools. We support connecting to data stored in these ways.

  • Pentaho data sources, such as relational Metadata data models or multi-dimensional Mondrian data models
  • JDBC databases

JDBC Database Connections

How you connect to databases depends on which access protocol is best to use when creating reports and data models or publishing them. You can choose from these access protocols.
Table 1. Database Connection Access Type Decision Table
Explore Considerations Choose Options
Native (JDBC) JNDI
Summary These connections are the easiest to define. However, they do not scale well and are not easy to maintain.

If the connection information changes, you must change it in every unpublished or published data model or report you have created with the design tools.

These connections are easier to maintain since only the connection name is stored, if the connection properties are stored in a file on each workstation the runs design tools.

Connection Behavior for Report Designer and Metadata Editor

The connection information is embedded into each report or Metadata data model. Once you have defined connections, the Report Designer displays the connection name in a list where you can select it. However, for Metadata Editor, once you have defined connections, you must enter the right connection name each time you use the editor.

Before you publish, ensure that the connection name is same name as a Native (JDBC) connection already defined on the BA server.

Connection Behavior for Report Designer and Metadata Editor

The connection information is stored in a properties file on each workstation that runs these tools.

Before you publish, ensure that the JNDI connection has the same name as one already defined on the BA server.

Connection Behavior for Schema Workbench and Aggregation Designer

Connection information is not embedded or stored. You must define the connection each time you use these tools.

Before you publish, you need to know the URL of the BA Server and the name of a Native (JDBC) connection already defined on that server.

Connection Behavior for Schema Workbench and Aggregation Designer

JNDI is not an option for these tools.

Before you publish, you need to know the URL of the BA Server and the name of a JNDI connection already defined on that server.

Expertise Knowledge of the JDBC driver and options for your RDBMS
Time Approximately 10 minutes for each workstation running the design tools Approximately 30 minutes for each for each workstation running the design tools
Recommendation Use for the Pentaho Trial Download and evaluation. But, switch each report and data model to JNDI before publishing to avoid problems if connection information changes. Use for production or when the work environment is distributed in a network.