FAQ

Can Emolysis read from SQL Server or PostgreSQL?

PostgreSQL is in development as a source and SQL Server is planned: Emolysis reads from them, lands the data on your platform and never deploys to them.

Answer

PostgreSQL is in development as a source, tested against local PostgreSQL servers; SQL Server is planned, with no date yet. Emolysis reads from SQL Server and PostgreSQL and never deploys to them. Their data lands in bronze tables on your production platform through the Ingest (batch), Incremental append and CDC merge shapes.

Each source has a profile like the platforms do: its dialect, the types that need care, the change capture options it offers and how sign-in works. For development, Emolysis samples a slice of the source into DuckDB on your machine so the golden tests can run locally.

The platforms page shows the role of each platform: target, source or local engine.