How to connect to AEM data with Tableau or other BI tools

Hi  Jason Mack

There is no integration or connector component between these two products. You would have to create a custom AEM service and integrate with Tableau using its Rest API - which it supports. Here is a community article on how to hook a Restful service into AEM.

Option 1 :-

Link: https://helpx.adobe.com/experience-manager/using/custom-sling-servlets.html

Creating Adobe Experience Manager bundles that invoke third party Restful web services

Create a OSGI service or Sling Servlets and write a code to send HTTP request GET/POST in it. 

Example Code :-

import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.methods.PostMethod;

String url = "http://www.google.com";
        InputStream in = null;

        try {
            HttpClient client = new HttpClient();
            PostMethod method = new PostMethod(url);

            //Add any parameter if u want to send it with Post req.
            method.addParameter("p", "apple");

            int statusCode = client.executeMethod(method);

            if (statusCode != -1) {
                in = method.getResponseBodyAsStream();
            }

Option 2:-

Tableau can be programmed using JAVAScript. We can use Java-scripting in AEM, you can achieve the needful with the same.

Link:-  https://helpx.adobe.com/experience-manager/using/custom-carousel-components.html

Link:- http://onlinehelp.tableau.com/samples/en-us/js_api/tutorial.htm

Link:- https://docs.adobe.com/docs/en/aem/6-0/develop/sightly/use-api-in-javascript.html

I hope this would help you. 

Thanks and Regards

Kautuk Sahni