Solved

Why don't I see any records returned for my Sage Intacct tables?

  • 27 March 2023
  • 1 reply
  • 109 views

Userlevel 2
Badge

I know I have data in my source but there a 0 records returned in my destination!

icon

Best answer by James T 27 March 2023, 20:42

View original

1 reply

Userlevel 2
Badge

Some source connections need additional permissions configured within the source when using CData’s embedded credentials. For compliance purposes, tables for some connections will seem like they are returning 0 results instead of throwing an obvious permissions error.

When authenticating to Sage Intacct with CData's embedded credentials, it is necessary to add "CData" to your Web Services authorizations within Sage Intacct in order to read all available tables (https://cdn.cdata.com/help/CTH/synch/default.htm#pg_connectionsynch).

You can confirm if this has been added or needs to be added by logging into your Sage Intacct account and navigating to "Company" >> "Setup" tab >> "Configuration" and selecting "Company".

Company » Setup » Company
​​

On the next screen, select the "Security" tab. If you don't see "CData" (case specific) under "Web Services Authorizations" you can add it by clicking on "Edit".

Web Services authorizations

 

Reply