Configuring the Adapter for TIBCO Data Virtualization

 

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.

To connect to a TIBCO Data Virtualization data source, the adapter requires connection and authentication information.

You supply this information using the SET CONNECTION_ATTRIBUTES command. You can:

  • Enter connection and authentication information in the WebFOCUS Reporting Server browser interface or ibi Data Migrator desktop interface configuration pane. The consoles add the command to the server profile you select: global (edasprof.prf), user (user.prf), or group (group.prf) if supported on your platform.

You can declare connections to more than one TIBCO Data Virtualization data source using the SET CONNECTION_ATTRIBUTES commands. The actual connection takes place when the first query is issued. If you issue multiple SET CONNECTION_ATTRIBUTES commands:

  • The connection named in the first SET CONNECTION_ATTRIBUTES command serves as the default connection.
  • If more than one SET CONNECTION_ATTRIBUTES command contains the same connection name, the adapter uses the attributes specified in the last SET CONNECTION_ATTRIBUTES command.

Configure the Adapter for TIBCO Data Virtualization

You can configure the adapter from either the WebFOCUS Reporting Server browser interface or ibi Data Migrator desktop interface.

    Procedure
  1. From the WebFOCUS Reporting Server browser interface Applications page, click Get Data or in ibi Data Migrator desktop interface, expand the Adapters folder.

    In the WebFOCUS Reporting Server browser interface, the Get Data page opens showing your configured adapters. In ibi Data Migrator desktop interface, the Adapters folder opens.

  2. In the WebFOCUS Reporting Server browser interface, click the (+) button, and find the adapter on the page or, in ibi Data Migrator desktop interface, expand the Available folder if it is not already expanded.

    In the WebFOCUS Reporting Server browser interface, you can select a category of adapters from the drop-down list or use the search option (magnifying glass) to search for specific characters.

  3. In ibi Data Migrator desktop interface, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Double click the adapter name.

    The Configure Connections pane opens.

  5. Enter values for the parameters required by the adapter, as described in the chapter for the specific adapter that you want to configure.
  6. Click Configure.

    The configured adapter is added to the Configured list in the WebFOCUS Reporting Server browser interface or the Adapters list in ibi Data Migrator desktop interface resources tree.

  7. After the adapter is configured, to review and change the connection attributes, right-click the adapter and select Properties.

    In the WebFOCUS Reporting Server browser interface, the adapter remains on the Available Adapters list with an asterisk to indicate that at least one connection has been configured.

Connection Attributes for TIBCO Data Virtualization

The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.

Connection name

A logical name used to identify this particular set of connection attributes. The default is CON01.

Host

Machine name where the TIBCO® Data Virtualization Server is running.

Port number

Port number on which the TIBCO Data Virtualization Server listens. The default port number is 9401.

Security

There are three methods by which a user can be authenticated when connecting to a database server:

  • Explicit. The user ID and password are explicitly specified for each connection and passed to the database, at connection time, for authentication.
  • Password Passthru. The user ID and password received from the client application are passed to the database, at connection time, for authentication.
  • Trusted. The adapter connects to the database using the database rules for an impersonated process that are relevant to the current operating system.
User

Primary authorization ID by which you are known to the data source.

Password

The password associated with the primary authorization ID.

Datasource

The data source name (DSN). There is no default data source name. You must select a value from the drop-down list.

Additional connection string keywords (Optional)

Enter additional connection string keywords to this field. Each keyword=value pair must be on a separate line. For example,

connectTimeout=0
unsupportedMode=silent

Refer to the latest TDV JDBC Driver Connection URL Properties documentation.

Advanced Parameters

There are two Advanced Parameters:

  • Allow Data Load. Select Yes to allow Upload, Quick Copy, and Custom Copy for a given connection. The default value is No.
  • Connection Description (Optional). User-defined notes used to describe the given connection. This parameter is optional.
Environment

Allows you to define required and informational Environment variables. You must define the required variables before starting the server.

There are two Environment parameters:

  • CLASSPATH. Directory search path for JVM or Java-based applications to find user-defined classes and packages, if not defined in IBI-CLASSPATH.
  • PATH. Directory search path for executable programs that are not in the current directory or called by full path name. To verify if this setting is required, check the vendor documentation.
Select profile

Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).

Store the connection attributes in the server profile (edasprof).

Declare Connection Attributes Manually

ENGINE SQLTDV SET CONNECTION_ATTRIBUTES connection 
'URL'/userid,password
SQLTDV

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

connection

Is the connection name.

URL

Is the URL to the location of the TIBCO Data Virtualization data source.

userid

Is the primary authorization ID by which you are known to the target database.

password

Is the password associated with the primary authorization ID.

Declaring Connection Attributes

The following SET CONNECTION_ATTRIBUTES command connects to a data source using the JDBC Driver, with an explicit user ID (MYUSER) and password (PASS). To ensure security, specifying connection attributes from the WebFOCUS Reporting Server browser interface or ibi Data Migrator desktop interface will encrypt the password before adding it to the server profile.

ENGINE SQLJDBC SET CONNECTION_ATTRIBUTES CON1
  'jdbc:xxxxxxx://hostname:port/datasource

Overriding the Default Connection

If multiple connections have been defined, the connection named in the first SET CONNECTION_ATTRIBUTES command serves as the default connection.

Change the Default Connection

ENGINE SQLTDV SET DEFAULT_CONNECTION connection

where:

SQLTDV

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

connection

Is the connection defined in a previously issued SET CONNECTION_ATTRIBUTES command. If this name was not previously declared, the following message is issued: 

FOC1671, Command out of sequence
Note:
  • If you use the SET DEFAULT_CONNECTION command more than once, the connection name specified in the last command serves as the default connection.
  • The SET DEFAULT_CONNECTION command cannot be issued while an uncommitted transaction (LUW) is pending. In that case, the following message is issued: 
    FOC1671, Command out of sequence.

Selecting the Default Connection

The following SET DEFAULT_CONNECTION command selects the database server named SAMPLE as the default database server:

ENGINE SQLTDV SET DEFAULT_CONNECTION SAMPLE

Controlling the Connection Scope

The SET AUTODISCONNECT command controls the persistence of connections when using the adapter for each of the connections you want to establish.

Control the Connection Scope

 
ENGINE SQLTDV SET AUTODISCONNECT ON {FIN|COMMIT}

where:

SQLTDV

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

FIN

Disconnects automatically only after the session has been terminated. FIN is the default value.

COMMIT

Disconnects automatically only after COMMIT or ROLLBACK is issued as a native SQL command.