Our sales and post-sales teams get a lot of questions regarding how can they report (think Tableau) on top of the data generated by the use of our enterprise application. We currently have CSV and Excel exports for a smaller chunk(view) of data, but that seems limited.
Now to go forward, there are multiple ways, but it boils down to exposing via API or exposing via a connector (ODBC, JDBC, etc). Correct me if I am wrong here. For B2C, API hands down wins, for B2B, how should we decide which is the best route? If we did go connector route, should we shortlist one or build multiple popular connectors? Did anyone face similar predicament? Any references/links are welcome as well!
