Home : Configuration - Source Configuration Q13605
Q13686 - INFO: Configuration - Source Configuration Q13605
Source Configuration is used to specify how to connect to the EDORS Oracle database that hosts the source table (DCS_POINTS_RETRIEVED) along with other options for the interface.   

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_RETRIEVED table (i.e. the source data 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_RETRIEVED 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  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:

There are no advanced settings for this interface.

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/25/2012 4:01 PM.
Last Modified on 2/2/2012 12:24 PM.
Last Modified by Scott Dorner.
Article has been viewed 2047 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article