How to connect to XML as an ODBC Data Source in Tableau
To connect to XML as an ODBC Data Source in Tableau, you would need to specify connection properties in an ODBC DSN (data source name). You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
The data provider models XML APIs as bidirectional database tables and XML files as read-only views (local files, files stored on popular cloud services, and FTP servers). The major authentication schemes are supported, including HTTP Basic, Digest, NTLM, OAuth, and FTP.
After setting the URI and providing any authentication values, set DataModel to more closely match the data representation to the structure of your data. The DataModel property is the controlling property over how your data is represented into tables and toggles the following basic configurations.
• Document (default): Model a top-level, document view of your XML data. The data provider returns nested elements as aggregates of data.
• Flattened Documents: Implicitly join nested documents and their parents into a single table.
• Relational: Return individual, related tables from hierarchical data. The tables contain a primary key and a foreign key that links to the parent document.
DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.