Transactional Databases

Transactional databases are row-stores (data is stored on disk as rows rather than columns) commonly used in production systems. They are used for OLTP use cases and are usually where your product's data is first stored before it's moved to your data platform. In some cases, such databases can also be used for analytics.

By integrating Sifflet with your transactional databases, you'll be able to leverage Sifflet's three core capabilities:

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

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

• Microsoft SQL Server
• MySQL
• Oracle
• PostgreSQL
• GCP Cloud SQL
• AlloyDB

Don't see your database on the list? Reach out to us and we'd be happy to discuss your use case!