Maconomy Enterprise Cloud Online Admin Guide

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Install and Configure the ODBC Driver

You must install and configure a driver on every workstation that will be used to connect to a database.

The user who installs the ODBC drivers must have local administrator privileges (at a minimum).

To install and configure the driver:

  1. Download the appropriate driver installer from the following links:

  1. Extract all the files in the downloaded ZIP file to a folder on your computer.
  2. From the folder downloaded in Step 2, run the executable for the architecture that matches the tool with which you will be connecting via ODBC (For example, if you are running 32 Bit Microsoft Excel, install the 32 Bit ODBC driver).
  3. Follow the prompts:
    1. Install Type - choose Standard Installation.
    2. Install Directory - we recommend file path C:\Program Files\Progress\DataDirect\Hybrid_Data_Pipeline_for_ODBC_4_6.
    3. Create Default Data Source - Leave the Create Default Data Source checkbox unchecked.
    4. Pre-Installation Summary - Click on Install.
  4. Execute the ODBC Administrator.
  5. From the ODBC Data Source Administrator dialog box, you can create either a User DSN or System DSN. User DSNs are for a single user; System DSNs are available to all users of the workstation. Select the User DSN or System DSN tab, based on your needs.
  6. Click Add. In the Create New Data Source dialog box, select DataDirect HDP 4.6 and click Finish.
  7. In the ODBC Cloud Driver Setup dialog box, enter a name in the Data Source Name field. This can be any name that helps you identify the data source.

    You do not need to add a value in the Description field.
  8. In the Hybrid Data Pipeline Source field, enter the Data Source name and the Service URL that you received from Deltek Customer Care when you requested the ODBC accounts.
    The Port Number field should be left to the default value of 443. If connecting to multiple product databases, you will need a separate DSN for each connection.
  9. On the Security tab, ensure that the Enable SSL checkbox is selected.
  10. Click Test Connect and enter the credentials that you received from Deltek Customer Care when your ODBC account was set up. Click OK.
    A Connection established! message displays. Click OK.
  11. Click Apply to save the configuration, then click OK and click OK in the ODBC Data Source Administrator dialog box.