We are currently implementing CData to sync to a data warehouse. I’m not non-techy guy on the team and we’re trying to figure out the tables and views that are listed in the Sage Intacct Connector for CData Sync - Data Model.
Are these the only tables/views available? Also, what’s the different between a table and a view? Why would a Gldetail and Glentry view, which should have the same columns, be different?
Thanks!
Steven
Hi
To answer you question, the Tables and Views listed under the Data Model in the help documentation represent the main tables and views exposed by our Sage Intacct Connector. However as our Intacct connector is a dynamic driver and is based upon the Sage Intacct API it can certainly expose other tables or views which they can access in their Sage Intacct account, including custom reports that would be exposed as Views once they are created. Read more here: https://cdn.cdata.com/help/CTJ/jdbc/pg_sp-createcustomreportschema.htm
The difference between a table and a view consists in the write functionality. Tables support both read and write operations, meaning SELECT, INSERT, UPDATE and DELETE statements whereas Views support only read operations (SELECT queries only).
As for your last inquiry, while GLDetail and GLEntry appear to share most of the columns there are certain columns that are supported only in GLDetail and others only in GLentry. This is because these two views are based on two different API endpoints. The GLDetail is based on the General Ledger Details object: https://developer.intacct.com/api/general-ledger/general-ledger-detail/#get-general-ledger-detail-object-definition
GLEntry is based on the Journal Entries object: https://developer.intacct.com/api/general-ledger/journal-entries/
In case the above do not answer your questions, feel free to reach out to our support team at [email protected].
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.