Anybody know of any pros cons to using CDATA vs us...
# integrationsr
Ricky
01/06/2022, 8:26 AMAnybody know of any pros cons to using CDATA vs using SuiteAnalytics Connect for ODBC? Thank you
s
scottvonduhn
01/06/2022, 2:02 PMSpeed. CDATA is significantly slower than the SAC ODBC driver. We used both for a while, and the performance of CDATA is not even close. However, CDATA does have the slight advantage of being able to query a saved search by id, and of being able to Insert & Update data.
But even then, I'd still use SuiteAnalytics Connect ODBC for data retrieval, especially if dealing with more than a few hundred records.
Ultimately, we abandoned CDATA and use web service for inserts and updates instead, as CDATA consistently struggled to insert data in reasonable amounts of time.
scottvonduhn
01/06/2022, 2:07 PMWe had some initially positive feedback when testing with small amounts of data, which turned into complaints when we scaled up. That didn't stop CDATA from using my earlier feedback on their customer testimonials (without my permission): https://www.cdata.com/company/testimonials.aspx
I have asked them to remove that, as I don't feel it accurately reflects my feelings of their software anymore, and our legal team has asked them to remove it, but they have refused to comply with our requests.
r
Ricky
01/06/2022, 10:34 PMThanks Scott!
d
darrenhillconsulting
01/07/2022, 7:46 PMhttps://www.tacticalconnect.com/ beats them all
2 Views