To DB

📄️ To DB - An Overview

When working within a Syntasa application, many transformations and operations are performed using processes like Spark processor, From DB, transform etc . These steps often generate output saved into an Event Store. If this processed or transformed output needs to be sent back to a database for reporting, analytics, or integration with other systems, the TO DB process is used.

📄️ Mapping Columns in 'To DB' Process

The Mapping screen in the TO DB process allows users to control which columns are exported to the target database and how they appear. This configuration is essential for aligning your output with the structure, naming conventions, and requirements of the destination database table.

📄️ Step by Step Guide to Export Data to External Database via To DB process

In this article, we will walk you through the complete process of exporting data from Syntasa’s environment to an external database using the TO DB process. This is useful when you have performed data transformations and want to push the final dataset into a database such as Postgres, Snowflake, or Athena for further reporting or operational use.