This blog will cover how we can perform SQL JOINS in Boomi. Prerequisites: We have to create two tables in the database named Employee_Blog and Department_Blog having columns Id, Name, Dept ID and Dept ID, Dept name respectively. Figure 1: Employee_Blog Figure 2: Department_Blog Step 1: Log on to the Boomi platform (https://platform.boomi.com/) with a […]
In this blog, we will see how to insert and query csv data from SQL Collection. What is SQL Collection? Step 1: Give your user credentials to log in to Workato. Step 2: Now click on create project. Step 3: Now give a project name and description and click on create project. Step 4: Now […]