Installation guide

Setting Description
Configure data source Access this window by clicking New, and selecting the New option on the
displayed screen. You can set the following options:
l Database type:use the dropdown menu to select your database.
l Settings:depending on the selected database, the specific setting options
will vary. The following settings are available (again, depending on the
database type):
l Path to <database type> database:type the folder path or click the ...
(browse) button to navigate to the location of the database file.
l Blank username and password:check this option if you do not want to
enter a specific set of credentials for accessing the database. If the option is
checked, the user is prompted to enter credentials to access the database
(usually this is not the preferred way of setting up the access, as
administrators do not want to put the burden of an additional authentication
on the user).
l SQLserver:use the dropdown menu to select the available SQL database
instance.
l Catalog/Database:use the dropdown menu to select the catalog you want
to use.
l TNS name:enter the TNS name of the Oracle server you want to use.
l Data Source Connection String:enter the connection string of your
database here.
l Build String:click this button to put together a database-specific
connection string.
l Test:after specifying the connection settings, you must click Test to check
whether the connection works. If the connection test is successful, you can
click OK to create the database connection.
Data link properties Access this window from the Configure data source screen, by selecting
Other as the database type, and clicking Build String.
Click through the options of this short Wizard to put together a connection
string for your database:
l On the Provider tab, select your OLE DBprovider, and click Next.
l On the Connection tab, enter the data source and login credentials into the
appropriate fields, and click Test Connection to check the data.
l On the Advanced tab, you can set the relevant network settings, connection
timeout, and access permissions to the database.
l On the All tab, you can check all the data link properties once more, and if so
inclined, you can edit them here manually, by simply clicking the row you
want to edit, and filling out the Property Value.
l Click OK to finish setting up the data link properties.