Shared OLAP Connection

Description

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

Inputs and Outputs

Database Connection Type - Specifies the type of connection to be used to connect to the database.

  • 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 OLAP Query actions can use this shared connection.