Is it possible to connect to adobe analytics API using SISS? I am working on an ETL process and was wondering if there was a particular driver to do this...
I have looked at Adobe Analytics documentation and there is not mention of drivers to connect to adobe analytics directly or with its API service.
I did not suspect they would make a specific driver for SSIS. Any third party drivers will be questionable from a cost and support stance. You will need to research how to make API calls from SSIS:
How to make an HTTP request from SSIS?
https://zappysys.com/blog/loading-data-from-rest-api-to-sql-server-in-ssis/
Fetch raw data from Google Analytics or Adobe Analytics in SQL
The last link mentions talking to Adobe Client Care. You might want to see if they have a utility that can export the data to a flat file. That will make your task much easier because then you can build a simple file loader.