Apama 10.3 | Apama Documentation | Building and Using Apama Dashboards | Building Dashboard Clients | Using SQL Data | Specifying application options | Adding a Database
Adding a Database
The Add Database dialog has the following fields:
*Database Name: The name to use when referencing this database connection in your data attachments.
*User Name: The user name to pass into this database when making a connection. This parameter is optional.
*Password: The password to pass into this database when making a connection. This parameter is optional.
*Use Client Credentials: If selected, the user name and password from the Apama login will be used instead of the User Name and Password entered in the Add Database dialog. Connections to this database will only be made when you are running with login enabled and a display is opened that accesses this database.
*As a result, this connection will not be made when you click OK or Apply in the Application Options dialog and will remain yellow. If you will be using the data server or the display server with a database connection that has this option enabled, you must enable Use Client Credentials for Database Login in these applications.
*Table Types: Specify the types of tables to retrieve when querying the database for available tables. Refer to your database manual for a list of valid table types. This parameter is optional. Table types are entered as a comma delimited list, for example, TABLE, VIEW.
*Run Queries Concurrently: If selected, each query on the connection is run on its own execution thread. The default is disabled. Note: This option should be used with caution since it may cause SQL errors when used with some database configurations and may degrade performance due to additional database server overhead. See your database documentation to see whether it supports concurrent queries on multiple threads.
*JDBC Driver Class Name: The fully qualified name of the JDBC driver class to use when connecting to this database. The path to this driver must be included in the RTV_USERPATH environment variable.
*JDBC Database URL: The full database URL to use when connecting to this database using the specified JDBC driver. Consult your JDBC driver documentation if you do not know the database URL syntax for your driver.
*Remove Database: Select a database from the list and click Remove Database to delete. Databases that are updating objects in a current display cannot be removed.
*Suppress Permission Errors From Database: If selected, SQL errors with the word "permission" in them will not be printed to the console. This is helpful if you have selected the Use Client Credentials option for a database. In this case, your login does not allow access for some data in their display, you will not see any errors.
*Get Tables and Columns from Database: If selected, information from your database will automatically populate drop down menus in the Attach to Data dialog and you will be able to select from available tables and columns in your database. Note: If a database repository is found, information from your database will be merged with data from the repository file.
*Save Database Repository: Click to save a file that records available tables and columns in your database and applies values to drop down menus in the Attach to Data dialog.
Instead of using the Add Database dialog, it is possible enter this information manually into OPTIONS.ini. See Entering database information directory into OPTIONS.ini.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.