Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Creates a connection to a relational database that can be used by multiple [OLAP Query] actions.
!sharedRelationConn.png|align=center,thumbnail! Image Added

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