Extract/Connect Adobe Analytics with SSIS to get aggregated data | Community
Skip to main content
G
guptavinay
August 26, 2021
Solved

Extract/Connect Adobe Analytics with SSIS to get aggregated data

  • August 26, 2021
  • 1 reply
  • 1802 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by amgup

@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/

1 reply

A
amgupAccepted solution
Level 7
August 26, 2021

@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/

    G
    guptavinayAuthor
    August 26, 2021

    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-server-ver15

     

     

    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

     

    A
    amgup
    Level 7
    August 26, 2021

    @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

    Terms & ConditionsAccessibility statement

    Loading footer...