skip to main content
Getting Started : Configuring and Connecting on Windows : Configuring a Data Source
  

Try DataDirect Drivers Now

Configuring a Data Source

To configure a data source:
1. From the Progress DataDirect program group, start the ODBC Administrator and click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
*User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.
If you are configuring a new user data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
*System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
*File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.
The General tab of the Setup dialog box appears by default.
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise in this book.
2. On the General tab, provide the following information; then, click Apply.
Data Source Name: Type a string that identifies this data source configuration, such as Accounting.
Host Name: Type the URL of the interface to which you want to connect.
Port Number: Type the port number of the server listener. The default is 27017.
Database: Type the name of the database to which you want to connect. The default is INFORMATION_SCHEMA.
Important: This value is case-insensitive if you have access privileges to query the list of databases on the server. If you do not have access, it is case-sensitive.
Schema Definition: Type the name and location of the configuration file where the relational map of native data is written. The driver either creates or looks for this file when connecting to the database. For example, C:\Users\Default\AppData\Local\Progress\DataDirect\MongoDB Schema\MainServer.config.
The default value is:
application_data_folder\Local\Progress\DataDirect\MongoDB Schema\host_name.config
where:
application_data_folder
is the application data folder for your platform and data source type.
host_name
is the value specified for the Host Name connection option.
See Schema Definition "Schema Definition" for details.
3. To take full advantage of the driver's features, click Schema Tool to customize your schema definition using the Schema Tool. You can also customize your schema definition later if the need arises. See "Creating and Customizing Schemas Using the DataDirect Schema Tool" for information about using the Schema Tool.