Hi Community,
We're looking to extract data from ServiceNow into a SQL Server/Data Warehouse on a weekly basis for Power BI reporting. This is a read-only integration covering Incident, Catalog Task, Task SLA, and Survey Results data.
Would you recommend using the standard Table REST API or a Scripted REST API? Initial testing will use Basic Authentication.
Has anyone implemented a similar solution? What worked best in terms of performance, maintenance, and incremental data loads?
Thanks in advance for your recommendations and lessons learned.
Regards
CarolMa
