CData Connector Fix

Fix:

1. Navigate to "ConfigureODBC" (C:\Program Files\CData\CData Power BI Connector for Bullhorn CRM) and run as admin.
2. Click "Reset Connection".
3. Delete the "OAuth Verifier" in the advanced settings.
4. Click "Test Connection".
5. Sign into Bullhorn using the API credentials (reach out to IT for them)
6. Copy the URL from the "=" to the "&" symbol.
7. Decode it (https://www.urldecoder.org/)
8. Copy the decoded value into the "OAuth Verifier" within the advanced settings of ConfigureODBC.
9. Click "Test Connection" and it should give you the message "Connection was successful", then click "OK"
10. Click "OK" on the ConfigureODBC to save and close.
11. Then choose the source and enter the source name "CData PBI BullhornCRM Source".
12. Then test by choosing a field from the table list.

If it loads up in PowerBI then the fix worked.