...

Creates a connection to a relational database that can be used by multiple OLAP Query actions.

Inputs and Outputs

...

• JDBC - Connect using a standard JDBC connection. The following inputs must also be provided.
  • JDBC Drive - Name of the JDBC driver class to use when connecting to the database.
  • Database URL - The database connection URL.
  • User Name - The username to use when connecting to the database.
  • Password - The password to use when connecting to the database.
  • Role - The Mondrian role to use with the connection.
• JNDI - Connect using the specified JNDI name. The following inputs must be provided:
  • JNDI Name - The JNDI data source name.
  • Role - The Mondrian role to use with the connection.

Mondrian Schema File - The location of the Mondrian schema file. This is only needed when using a JDBC or JNDI connection.

Connection Name - The name of the resulting output database connection. Following Relational OLAP Query actions can use this shared connection.