Transactional Databases

What Is a Transactional Database?

Transactional databases are row-stores (data is stored on disk as rows rather than columns) commonly used in production systems. Teams use them for online transaction processing (OLTP) use cases, and they usually store your product's data before it reaches your data platform. In some cases, you can also use such databases for analytics.

Why Connect Sifflet to Your Transactional Databases?

By integrating Sifflet with your transactional databases, you can use Sifflet's three core capabilities:

• Run monitors on your data assets to detect issues as soon as they arise and allow data consumers to trust the data.
• Catalog all your data assets (with valuable metadata retrieved from the database and enriched directly in Sifflet).
• Benefit from Sifflet's end-to-end lineage that shows your data pipelines and the assets upstream and downstream of your transactional database.

Sifflet's Transactional Database Integrations

Sifflet connects with a wide range of transactional databases and their cloud variations:

• Microsoft SQL Server
• MySQL
• Oracle
• PostgreSQL
• Google Cloud SQL, for PostgreSQL, MySQL, and SQL Server
• AlloyDB for PostgreSQL

If your database is not on the list, contact Sifflet support to discuss your use case.

Refresh Frequency

See Integrations Management for the default refresh frequency and how to change it.