Home : Configuration - Source Configuration Q13645
Q13657 - INFO: Configuration - Source Configuration Q13645
Source Configuration is used to specify how to connect to the EDORS Oracle database that hosts the destination table (DCS_POINTS_TO_PROCESS) along with other options for the utility.   

From the main screen, click Configuration and select Source Configuration.

The next screen will display parameters on two tabs. The first is Database Connection, this is where you setup the connection to the database that hosts the DCS_POINTS_TO_PROCESS table (i.e. the data request table):

  • Configuration Template - two possible templates are included in the utility; one for Oracle and one for User Defined. These will fill in the most common values for the database connection.
  • DBMS Type - Select the database system type from one of these:
    • Oracle
    • Microsoft SQL Server

  • OLE DB Provider - this will be filled in with Configuration Template and DBMS Type, and can be modified if needed.  Should be set to OraOLEDB.Oracle.
  • Data Source - this field specifies, in loose terms, the "Database/Datasource server name" where your source database system is configured to store data.  In Oracle, this is your net service name typically aliased in your tnsnames.ora file. 
  • Database Name - For Oracle, this is the USER/Schema Owner for the DCS_POINTS_TO_PROCESS table. 
  • Username - The database username you want to use to connect to the database. This user should have permission to access the database and tables that contain data.
  • Password - The password associated with the Username and is used to connect to the database.
  • Advanced Configuration - these permit adjustment of the command and connection timeout.

    • Connection Timeout in Seconds - how many seconds the program should wait when establishing a connection to the source database server.
    • Command Timeout in Seconds - specifies how many seconds the program should wait for a query to complete before aborting the operation.
  • View Applied Connection String button will expose the currently applied connection string to source. Copy and Paste operation can then be performed.

 

The second tab is Advanced Settings:

Ignore Case when matching between Source Identifiers and WIMS Variable Cross References - enable this setting when you need to ignore case during matching to WIMS variable cross references.

Link to Interface:  Specifies the Interface the Utility will use to find the WIMS Variables to request data for.  For example, the utility will request data for all variables in WIMS with the Interface To: set to Ovation API:

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/3/2012 11:42 AM.
Last Modified on 1/24/2012 11:01 AM.
Last Modified by Scott Dorner.
Article has been viewed 2339 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article