...
Creates a connection to a relational database that can be used by multiple [OLAP Query] actions.
!sharedRelationConn.png|align=center,thumbnail!
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.