Extract/Connect Adobe Analytics with SSIS to get aggregated data

[guptavinay]

Hi Community,

Subject : There is a requirement to extract data from Adobe Analytics using SSIS.

Hi All - anyone have some idea about how I can connect Adobe Analytics Metrics or SEGMENTS through SSIS for automation purpose.

To validate the Adobe data as a source of truth and secondary data which is available in my SQL server.

Please anyone provide the better options - If need more explanation I am happy to explain more here.

Thanks,
Vinay

[amgup · Accepted solution]

@guptavinay  I am not aware of the SSIS but to extract the data you can use the Reporting API. Link is given below. 

Note:- In order to access the API you should have the required access of developer rights from admin console.

If you want to use the SSIS only than please help us in explaining more about SSIS.

https://adobedocs.github.io/analytics-2.0-apis/

[guptavinay]

Many thanks @amgup for support.

So more about SSIS.
SSIS is Microsoft SQL Server Integration Service ETL tool - with help of SSIS we can extract transform and Load the data. it is Just a ETL tool.

So, Here I am looking any connector of Adobe to use in SSIS for Data Connectivity, connect with adobe and extract into CSV or Excel as per my customer requirement -

More about SSIS

https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-s...

FYI : My customer already they have Adobe Analytics account from where they are seeing the reports/metrices. 

Last not least - Just I need a Idea or solution how I can do Adobe data connectivity with SSIS.

Thanks,
Vinay

[amgup]

@guptavinay  I am afraid if it is possible from Adobe interface but you might want to check the below document :-

https://www.cdata.com/kb/tech/adobeanalytics-ssis-task-import-2008.rst