Adding a Data Source
This section is an overview of the process for adding a data source. It includes the following topics:
To add a data source
1. In the Studio navigation tree, select the directory in which you want the new data source to reside.
2. Right-click and choose New Data Source from the popup menu, or choose the File > New > Data Source option.
Studio opens the New Physical Data Source dialog. This dialog displays currently supported and custom-defined data source adapters in the Select Data Source Adapter pane.
3. Optionally, if one of the built-in adapters do not fit your data source, you can create a new, custom adapter (see
Custom Adapters).
4. Optionally, if you are unsure of the data sources you want to define or that are available to you on your network, you can auto-discover resources (see
Auto-Discovering Data Sources).
5. Search for and select the adapter to use to connect to your data source, and click Next.
The configuration window that is displayed depends on which data source adapter you have selected.
6. Provide the data source connection information to configure your data source:
a. For Datasource Name, enter a unique user-defined name for the introspected data source. It can be any name that is valid in TDV. This name will be displayed in the resource tree when the data source is added to the TDV Server.
b. For Connection Information on the Basic tab, supply the required information. Required information will vary depending on the type of data source you are adding.
— Username and Password—Valid username and password to your data source.
— Save Password and Pass-through sign-in —These fields work together. Discussion for how they work is in the TDV User Guide.
c. Click the Advanced tab, specify details about the connection.
Some properties refer directly to the configuration of the data source Server and must be provided by an Administrator. Other properties are specific to TDV and how it interacts with the data source.
— Connection Pool Minimum Size, Maximum Size, Idle Timeout(s), and Maximum Connection Lifetime—These control the JDBC connections made to the data source, specifying timeout in seconds, the minimum and maximum number of simultaneous connections in a connection pool.
— Connection Validation Query—A simple query to test whether the connection is valid or not. You can leave it empty, or use simple queries like “select * from dual.”
— Organization Id Cache Timeout Seconds—Length of time to cache user security information. After this time the security information is refreshed from the data source. If a user's security information is changed before the cache is refreshed, the changes will not be available to the Suite data source until the cache is refreshed.
For the specific connection information needed to configure each data source see:
— Configuring Web-Based Data Sources
— Configuring File Data Sources
For information on configuring any of the Advanced Data Sources, see the additional adapter guides that are provided as online help or in PDF form.
7. Create the data source using one of these buttons:
— Click Create & Close to create this data source which can be introspected later.