Join us on a journey towards creating a customer 360 marketing strategy. With Astera, you can seamlessly integrate data from various data sources and combine it into a single source of truth and make your data analysis ready.

In this video, we will be learning how to seamlessly integrate SQL code stored in a.SQL file into a workflow, automating database operations effortlessly by using the Run SQL File Task. The Run SQL File task runs the SQL code inside a file of.sql extension as part of a workflow.

In this video, we will learn the functionality and usage of the Decision workflow task within Astera Data Stack. The Decision task allows for conditional branching in workflows, directing the flow based on logical expressions.

In this video, we will be learning about the functionality and features of the Server Browser present within Astera Data Stack.

In this video, we will be discussing how you can extract data from an XML JSON File Source using the XML JSON File Source object in Astera. XML JSON file source in Astera provides a high-speed reader for XML or JSON files in which the data is stored in a hierarchical format within several nodes and sub nodes. Contents of the video: Configure the object properties, including File Path, Schema Location, and other options. Generate XML Schema. Customizing XML Layout and Config Parameters. XML data preview.

In this video, we will be discussing how you can extract data from a delimited file using the Delimited File Source object in Astera. Delimited files are one of the most commonly used data formats and use specific characters or delimiters to separate records and indicate the structure of the table in which the data resides. Contents of the video.

In this video, we will see how a Database Table Source object works in Astera. The Database Table Source object is used to retrieve data from a database table. It offers incremental reads via change data capture, supports multi-way partitioning for enhanced performance, and allows customization with WHERE clauses and sorting options.