Resolving the ODBC Error: "Invalid User ID or Password"

If Mosaic Admin notifications alert you with the following message:
Error from Deltek Ajera:[DataDirect][ODBC Hybrid driver][Service]Invalid user ID or password, it implies there's an issue with the ODBC Account credentials.

Step 1: Obtain a New ODBC User Password from Deltek Support

🚧

Please Note:

The error message Error from Deltek Ajera:[DataDirect][ODBC Hybrid driver][Service]Invalid user ID or password refers specifically to the ODBC Account and not the Deltek Ajera API User. You'll need to contact Deltek Support to change the expired ODBC Account Password.

To address this, please contact Deltek Support to request an updated ODBC Account Password following these steps:

1. Your company’s SaaS Customer Administrator should log into the Deltek Support Center and navigate to the Deltek Cloud Solutions page.
2. In the Service Request section, select the ODBC Read Only Access radio button.
3. Click the link in the Service Request to download the spreadsheet that should be used to log all
   changes to ODBC access. The spreadsheet can also be downloaded from KB Article # 107175.
   1. Enter the First Name, Last Name, Email Address, and Ajera database Company Name(s) for the existing ODBC Account used to connect the integration.
   2. In the Action column, select Change Account Password.

4. Under User Access Form, select Choose File and upload the completed spreadsheet from step 3
   above.
5. Click Submit.

• Upon submission, a dialog box displays containing the Case No. for the request and a link to Manage
  Cases, where the case can be viewed or updated.

6. Upon the completion, Deltek will notify the Account holder via email with the credentials and
   configuration settings needed to connect to the ODBC service.

• Additionally, the SaaS Administrator will receive a confirmation email when the request is completed.

❗️

Your Deltek ODBC Account have a validity period of 120 days:

Please be advised that passwords for Deltek's ODBC Accounts have a validity period of 120 days. Ensure to update the passwords in Deltek and Mosaic accordingly to maintain uninterrupted service.

Step 2: Update the ODBC Credentials in Mosaic

Once you've received the updated password from Deltek Support, follow these steps to update Mosaic:

1. Navigate to the Deltek Ajera Integration section and click on the Gear icon.

2. A pop-up titled "Integration Settings" will appear. Scroll to the bottom of the pop-up and click Update credentials.

3. Next, check the box labeled Update ODBC Credentials.
4. Input the new credentials:

   📘

   Only update the required fields

   Your current credentials will pre-populate on this page and can be left as-is if you are not intending to change them.

   i.e. Leave the pre-populated fields for ODBC Username, ODBC Data Source, and ODBC Service URL as they are if you are only updating the password.

5. After entering the new details, click Update.

6. Ensure you see a confirmation message that reads: Successfully updated credentials.

By following these steps, you should have resolved the ODBC error. If issues persist, consider reaching out to Deltek Support for confirmation that the credentials are valid and/or your Mosaic Customer Success Manager.