To define the parameters of a data source:
Right-click Data Sources in the physical tree, and select New, then Data Sources.
The Define Parameters page of the Connection Wizard is displayed.
Select the appropriate Data Source Type.
For example, if you are creating a connection to a Microsoft SQL Server data source, select Microsoft SQL Server from the drop-down list.
Oracle BI EE users: Choose an Oracle BI EE layer for this data source connection:
Presentation Layer—A customized view of metadata in the business model.
Business Model—The mapping of objects in the physical data source to metadata.
In Server Name, enter the name of server where the database resides.
Oracle users: If you are connecting to an Oracle database, in the Oracle SID/Service Name group, enter the SID or Service Name for your Oracle instance.
Optional: To use a port number other than the default, clear the Default check box next to Port and enter the correct port number in the text box.
If you are using the default port number, you can skip this step.
In Database Name, select the name of the database to which you want to connect.
If you do not know the name of the database to which you want to connect, click the Fetch database button next to the Database Name. Select the database from the list of the databases available on the server you designated in step 7.
IBM DB2 users only: You must type the database name; you are not presented with a list of databases from which to choose.
IBM DB2 users only: In Authentication Method, select an option:
No Encryption
Encrypt Password
Encrypt UserID and Password
Client
Note:
When you specify an authentication method other than “No Encryption” for a data source, then you must perform cube deployments in “streaming” mode. Set the server.essbase.streamingCubeBuilding property to “true” to enable deployments in streaming mode. See server.essbase.streamingCubeBuilding for more information on this property.
Optional: Modify the Connection Pool settings.
Pool Max Size, together with Cache Size, controls connection pooling for data source connections. Connection pools allow several tasks to query the same data source connection concurrently.
In Pool Max Size, enter a number to change the maximum number of connections in the connection pool.
Pool Max Size specifies the maximum number of connections in the connection pool. If the number of connections required exceeds the number of connections specified in Cache Size, Essbase Studio Server opens temporary connections until the value specified in Pool Max Size is reached. As the number of connections required decreases, the temporary connections are destroyed.
To make changes in the default value shown in Pool Max Size, modify the server property, pool.maxsize, as described in data-source-type.pool.maxsize.
In Cache Size, enter a number to change the internal cache of physical connections in the connection pool.
The internal cache consists of physical connections that are always open. Some or all of the connections may be in use concurrently.
To make changes in the default value shown in Cache Size, modify the server property, cache.size, as described in data-source-type.cache.size.
Optional: Click Test Connection.
If the information you entered in the wizard is correct, a message confirms a successful connection.
If you entered incorrect information in the wizard, a message is displayed explaining that invalid credentials have been provided. Correct the errors and retest until the connection is successful.
Clicking Next takes you to the Select Tables page of the wizard, described in Selecting Tables for Relational Sources.