Hello is it possible to export all the SFMC analytics data to an outside BI. What I'm trying to do is have an MDM then that MDM will connect my SFMC to a BI Cognos.
Yes, very much and there are multiple ways you can extract tracking data out of SFMC -
For SMS Tracking, look at the Tracking section on the page below. Although it is not as comprehensive as Email -
From my experience, use a combination of Queries and Tracking Extracts and get the data into your MDM for analytics. Hope this helps
As @ Maneesh explained those are a few of the common options. There are some caveats depending on the volume of data. Using the SOAP API there are some limits in terms of the amount of data that can be pulled, so you need to care for managing the multiple transactions needed to page and pull larger data volumes. For example, if you have thousands, or even millions, of subscribers as part of your list(s), then you will want to factor that into your approach. Also, depending the volume of campaigns and the configuration of your account, certain approaches may work better than others. For example, some people teams want to have more of a real-time transactional view by campaign. All of this then needs to align with how you pipeline data in Cognos.
We have done various integrations with SFMC to support the exact use case you are describing. If you want to discuss further, just send me a note.