I'm exploring ways to export data from Dynamics AX 2012 as this will be one of the key data sources which is required to build an external data warehouse outside the Microsoft suite. Tableau will be connected to the warehouse for reporting purposes.
Hoping to avoid coding in X++ and also 3rd-party ODBC connectors.
Looking for specific ways to perform exports to excel, csv etc.
Hoping to find some guidance in this area. Thank you!
So this question isn't necessarily about how to connect Tableau to Dynamics but how to get data out so you can build out an ETL workflow to a data warehouse? If so, then doesn't Dynamics use a backend SQL Server database? Can you just connect to the SQL database and extract the data?