The BI Connector is a powerful tool that bridges the gap between Business Intelligence (BI) tools and databases. It allows users to leverage their existing BI software to visualize, analyze, and report on data stored in a variety of databases, without needing to understand complex database languages. By using the BI Connector, businesses can gain deeper insights into their data and make better-informed decisions.

<aside> 💼 The BI Connector is an additional service that comes at a cost, since it requires us to establish and maintain a new database that comes at cost and effort on our part. Therefore this tool should be considered for larger clients more than smaller ones.

</aside>

General Information

What is the use case for the BI Connector?

<aside> 📈 The BI connector is built mainly to be used for Quantitative Analytics processes outside of the platform, using the data to aggregate reports on **trends and numbers over time

For example:** generating a report on hires over time by recruiter

</aside>

BI connector is a great tool to connect Teamtailor’s data into your Data Warehouse and Business Intelligence solutions, the purpose of which is to provide data for quantitative analysis, that shows aggregated numbers over time rather than in-depth qualitative analysis that would focus on specific cases.

The data provided is essentially the same that our Analytics solutions uses for displaying reports. In those cases where you want to enrich that data with external information or create reports that are a bit more complicated and more suited to your needs, it is a great tool to achieve that.

Some valid use cases:

What is out of scope for BI Connector?

<aside> 📌 The BI connector is not built for Qualitative Insights or data and document extraction in mind, those use cases are not forbidden but are simply not intended or supported by us.

For example: not possible to do an analysis of interview notes, recruitment goals, specific cases and so on, as such data is not available in the BI connector.

</aside>

While the data provided does contain qualitative information, the intention behind it is not to perform qualitative analysis, extract data for non-analytics use, extract files and other similar information for other purposes. While we do not forbid such uses, we cannot fully support them either, since the tool is not built with that in mind.

If you are unsure - reach out to us with your use case so we can check if it is supported by this tool before ordering.

What kind of data can I find there?

You can find all the Schema tables detailing available information here:

Schema Tables