SQL
The SQL importer is capable of executing queries on SQL data sources and extracting information from the results. Due to the wide usage of SQL as a database backend, this data source is often a fallback if no vendor-specific importer exists for a given source of data e.g. for a non-supported CMDB or monitoring tool.
The functional principle of this importer is a query simply sent to a SQL server and the results being retrieved. The usual filtering and dynamic columns tools of Txture's importing infrastructure can be used normally. Note however, that the given query is wrapped into
select * from ( ... ) where 0 = 1
to fetch the schema. This raises the limitation that with clauses can not be used in MSSQL or PostgreSQL as with clauses may only occur in the execution scope.