Creating a Data Source in Information Designer

To create a new data source:

  1. In Information Designer, on the Start tab, click Setup Data Source.

    Response: A Data Source tab is displayed.

  2. In the Name field, type the name of the new data source.

  3. Specify the Type of the data source.

  4. Modify the Connection URL.

  5. Type a Username and Password that gives access to the data source.

  6. Select whether a user must be authenticated when accessing the data source.

    Response: If this option is selected, authentication is required when accessing this connection, either by the user or by a plug-in. If not selected, the credentials supplied above will be used for all users. Even if user authentication is selected, Username and Password must be supplied since they are used by Information Designer. When using a data source with user authentication the database administrator needs to make sure that the data source user has sufficient privileges, so that it is allowed to truncate and drop temporary tables in the data source.

  7. Enter any additional configuration settings.

  8. Click Save.

Note: If you are connecting to a non-writable data source (for example, SAS/SHARE or ODBC) you must clear the Allow writing in temporary tables check box.

Note: For SAS/SHARE and ODBC data sources, both Min and Max No of connections should be set to 0 in order to disable connection pooling. The same holds for other data sources that do not support pooled connection since there is no valid ping command.

See also:

Data Overview

What is a Data Connection?

Data Source Tab

Data Sources Overview