Appboard/2.4/builder/data sources/third party: Difference between revisions
imported>Mike.berman (created page) |
imported>Mike.berman No edit summary |
||
| Line 73: | Line 73: | ||
|- | |- | ||
|'''driver''' | |'''driver''' | ||
| | |The Java class name for the JDBC driver. Example: <tt>oracle.jdbc.driver.OracleDriver</tt> | ||
|- | |- | ||
|'''connectTimeout''' | |'''connectTimeout''' | ||
| | |Time (in seconds) after a timeout occurs to wait before attempting to re-establish the connection. Setting this value too low can impact the performance of the system. | ||
|- | |- | ||
|'''timeout''' | |'''timeout''' | ||
| Line 85: | Line 85: | ||
|- | |- | ||
|'''catalogName''' | |'''catalogName''' | ||
| | | Database catalog name. It is not required, used to limit the set of tables found on the search. | ||
|- | |- | ||
|'''schemaName''' | |'''schemaName''' | ||
| | |The database schema name. It is not required, used to limit the set of tables found on the search. | ||
|- | |- | ||
|'''tableNameRegex''' | |'''tableNameRegex''' | ||
| Line 94: | Line 94: | ||
|- | |- | ||
|'''ansiMode''' | |'''ansiMode''' | ||
| | |Check this box if your database is running in ANSI mode. Some databases (including MySQL and SQL Server) provide this variation on the character used to quote elements such as columns when the SQL statement is being constructed. | ||
|- | |- | ||
|'''host''' | |'''host''' | ||
| Line 106: | Line 106: | ||
|- | |- | ||
|'''url''' | |'''url''' | ||
| | |The JDBC connection string/URL for defining the connection. This typically contains information about the database server and name, the user id, a password for connecting to the database, and an Oracle SID at the end which uniquely identifies the name of a particular database to connect to. Example: <tt>jdbc:mysql://myservername:3306/mydbname</tt>. The default connection string provided when you create the JDBC/Oracle adapter Data Source in AppBoard is the following: <tt>jdbc:oracle:thin:@localhost:1521:portal</tt>. Note that the sample URL string contains an Oracle SID at the end ("portal"), which uniquely identifies the name of a particular database to connect to. It is recommended that you make sure the connection string includes this SID so the connection can be made between AppBoard and the database. You may need to ask the database or application administrator to provide the Oracle SID for the database. Example Oracle URL: <tt>jdbc:oracle:thin:@servername:1521:OracleSID</tt> | ||
|- | |- | ||
|'''username''' | |'''username''' | ||
Revision as of 06:06, 29 August 2013
Third Party Data Adapters provide some pre-configured options for loading data from certain popular data sources. This page details the options available for each of the Third Party Data Adapters.
HP NNMi
The HP NNMi adapter retrieves information about nodes and incidents from the HP Network Node Manager (NNMi) application.
Connecting with HP NNMi
Perform the following steps to configure an HP NNMi Data Adapter:
- Log in to AppBoard as an administrator.
- Select Data Sources to launch the Data Source Administration panel.
- Click Add.
- Enter the name of the Data Source.
- Select the Third Party adapter type.
- Select the HP NNMi adapter.
- Click Add Data Source.
- Enter the configuration items as detailed in the following table:
| Name | Description |
|---|---|
| url | The url for accessing the HP NNMi application. |
| httpAuthUsername | The Username for accessing the HP NNMi application. |
| httpAuthPassword | The Password for accessing the HP NNMi application. |
| cacheTimeout | Time limit before re-loading results from the database. |
IBM Tivoli Netcool/OMNIbus
The IBM Tivoli Netcool/OMNIbus adapter retrieves information from a Tivoli Netcool/OMNIbus object server.
Connecting with IBM Tivoli Netcool/OMNIbus
Perform the following steps to configure an IBM Tivoli Netcool/OMNIbus Data Adapter:
- Log in to AppBoard as an administrator.
- Select Data Sources to launch the Data Source Administration panel.
- Click Add.
- Enter the name of the Data Source.
- Select the Third Party adapter type.
- Select the IBM Tivoli Netcool/OMNIbus adapter.
- Click Add Data Source.
- Select a template (database type) from the drop-down list provided.
- Enter the configuration items as detailed in the following table:
| Name | Description |
|---|---|
| driver | The Java class name for the JDBC driver. Example: oracle.jdbc.driver.OracleDriver |
| connectTimeout | Time (in seconds) after a timeout occurs to wait before attempting to re-establish the connection. Setting this value too low can impact the performance of the system. |
| timeout | Time to wait before timing out on connecting to the datasource. |
| cacheTimeout | Time limit before re-loading results from the database. |
| catalogName | Database catalog name. It is not required, used to limit the set of tables found on the search. |
| schemaName | The database schema name. It is not required, used to limit the set of tables found on the search. |
| tableNameRegex | Regular expression specifying which tables you want returned from the server. |
| ansiMode | Check this box if your database is running in ANSI mode. Some databases (including MySQL and SQL Server) provide this variation on the character used to quote elements such as columns when the SQL statement is being constructed. |
| host | IP Address or DNS resolvable host name. |
| port | TCP port for the server connection. Default is 4100. |
| dbname | server name / database name. |
| url | The JDBC connection string/URL for defining the connection. This typically contains information about the database server and name, the user id, a password for connecting to the database, and an Oracle SID at the end which uniquely identifies the name of a particular database to connect to. Example: jdbc:mysql://myservername:3306/mydbname. The default connection string provided when you create the JDBC/Oracle adapter Data Source in AppBoard is the following: jdbc:oracle:thin:@localhost:1521:portal. Note that the sample URL string contains an Oracle SID at the end ("portal"), which uniquely identifies the name of a particular database to connect to. It is recommended that you make sure the connection string includes this SID so the connection can be made between AppBoard and the database. You may need to ask the database or application administrator to provide the Oracle SID for the database. Example Oracle URL: jdbc:oracle:thin:@servername:1521:OracleSID |
| username | Username credential used to connect |
| password | Password credential used to connect |
| poolsize | Number of connections to pool |
