SSIS ETL from Rest framework

New Contributor

Hi All, Need to drag data from Casper into a BI originally created for SCCM. Need to load BI with SSIS with large amounts of Casper data. Prefer database to database exchange or simple extract to CSV. Looking at the REST API and not seeing SSIS compatible output. XML output for large data volume is slow and data heavy, and without XSD's for format support. Our BI structure is SCCM centric, complicating our data mapping and summarization.

Ideally there is a command line extract example for the REST interface that produces CSV and not XML.

Trying to avoid re inventing the work flow. Our experience with the JAMF Plugin for SCCM for 2007 was rejected by our customers, and not politically possible for SCCM 2012.