Mapping Unstructured Data: How-to
Summary
This is necessary because ODBC and SQL require and operate on data that is organized with a fixed schema and returned in a tabular structure. By utilizing the SimbaEngine SDK, you can efficiently map your data into a relational format, enabling you to build an ODBC driver compatible with various application vendors, including Power BI, Tableau, Qlik Sense, Alteryx, Informatica, MicroStrategy, Logi Symphony, Excel, and more. Once you have identified the complete set of fields, you can begin mapping this data to a relational model. Over the years, we have encountered a variety of data types and successfully mapped all of them into sensible relational representations. Once this mapping is complete, it takes just five days to have your read-only ODBC driver up and running, connecting to the application vendor of your choice!