Skip to content

DataSplice Support Website

Sections
Personal tools
You are here: Home » Product Manuals DataSplice 3.0 » DataSplice Administration Client Manual » ADO.NET Data Source Plug-in Configuration
 

ADO.NET Data Source Plug-in Configuration

Connectivity to traditional databases is provided by the ADO.NET data source plug-in. This plug-in is provided with the default installation package. The plug-in uses the ADO.NET library to connect to target databases, perform queries, and process modifications. Native providers are used if possible. This provides enhanced performance and functionality over generic technologies such as ODBC and OLE DB. However, legacy support for these drivers is still available if necessary.

Connection Profiles

The DataSplice Server uses connection profiles to define the settings used to connect to external data sources. Each view specifies a particular connection profile to use.

Connection profiles allow settings for multiple views to be quickly changed, since the details only need to be modified for the connection profile once. This is particularly useful for moving from a test to a production setup, for example.

Configuring the ADO.NET Data Source Plug-in

  1. Expand the Server Plug-ins section by clicking the plus sign.
  2. Select ADO.NET Data Source Plug-in from the list of available plug-ins.

    Plug-ins List

  3. In the Configuration Section drop-down list, select Edit Options.

    Plug-in Options

  4. In the Basic Options section, complete the fields as desired:

    Option Name Option Value
    Query Cache Timeout The amount of time, in minutes, to cache query schema information. Actual data is not cached, but the plug-in's meta-data is. During the development of a DataSplice implementation, this should be set to 0. When this cache is off, each database statement (select, insert, update, or delete) results in two trips to the database.
    Note: setting this value to 0 turns caching off. Setting this value to -1 caches objects to memory for the life of the DataSplice Server.
    Stored Procedure Cache Timeout The amount of time, in minutes, to cache stored procedure names and parameter information. If stored procedures are being changed during the development of a DataSplice implementation, this should be set to 0 during the development process. When this cache is off, each stored procedure call results in two trips to the database.
    Note: setting this value to 0 turns caching off. Setting this value to -1 caches objects to memory for the life of the DataSplice Server.
    Maximum Fetch Count Maximum number of records to fetch for a single query. This setting prevents a malformed query that would otherwise return millions of records from consuming server resources. Properly designed views should not need to return 20,000 records, but loading large quantities of offline data could exceed the default setting.

  5. In the Database Connection Profiles section, click the Add Configuration Section button Add Configuration Section Button and complete the fields appropriately:

    Column Name Description
    Name This is the unique name used by DataSplice to identify this connection profile. This name is referenced by all DataSplice views to specify the data source to gather data from.
    Important: This name is case-sensitive.
    Driver This drop-down list contains the available native database drivers. Select the corresponding driver describing the specific platform in use. Refer to the database driver reference page for some general suggestions for common database platforms.
    Server This is the server entry in a valid ADO.NET connection string.
    Note: For Oracle, the server entry usually corresponds to a tns entry. In SQL Server, the server entry is usually the name of the machine where the database resides.
    User Name This is the user name that the DataSplice Administration Client will use to connect to the data source. This user should have sufficient permissions to access the target data.
    Password This is the password that the DataSplice Administration Client will use to connect to the data source. This password corresponds to the user name given in the previous field.
    Initial Catalog When applicable, this is the database instance to use when multiple databases are present.
    Trusted Connection When this checkbox is enabled, the same credentials used to launch the DataSplice Server application will be used to authenticate against the database.
    Extra Options This allows additional connection settings to be passed to the database in the connect statement by appending this value to the basic connect statement generated by DataSplice. Consult the documentation for the database provider for a list of valid parameters.
    Pass Through Authentication When this checkbox is enabled, the plug-in will pass-through to the database the user name and password supplied by the user in the Remote Client. This requires the accounts used by DataSplice to have valid corresponding accounts in the database. Needless to say, this will cause the server to open more database connections.
    Verify Connection When this checkbox is enabled, upon saving the connection profile settings, DataSplice attempts to connect to the data source to ensure that the settings are correct.

  6. Click the Save Changes button Save Changes Button to submit the changes.

Contents
 


Last modified 2007-02-23 12:22 PM
 
Powered by Plone

This site conforms to the following standards: