Skip to main content

​
• Orchestrating Data Workflows

An Ekyam Workflow is a configurable, automated sequence of data transmissions and operations that defines how Ekyam processes events and moves data between one or more source systems and one or more destination systems. Workflows are the core of Ekyam’s business process automation capabilities. Defining Business Logic Ekyam Workflows allow users to embed sophisticated business rules and logic directly into the integration flows without extensive custom coding. This is achieved through a user-friendly interface that supports various operations, including: Image(47) Pn
  • Mathematical Operations: Perform calculations on data fields (e.g., calculate total order value including tax, convert currencies).
  • Logical Operations: Implement conditional logic (IF-THEN-ELSE statements) to route data differently based on specific criteria (e.g., if order value > $500, flag for expedited shipping).
  • String Operations: Manipulate text data (e.g., concatenate address fields, parse product descriptions, change case).
  • Database Operations: Look up additional information from connected databases to enrich data in transit (e.g., fetch customer loyalty status based on customer ID).
  • Transformations: Apply complex data transformations beyond simple field mapping.

​
• AI-Powered Workflow Capabilities

Ekyam Workflows integrate advanced AI capabilities, empowering users to build even more intelligent automations:
  • AI-Based Queries: Users can employ natural language prompts to query data within the Ekyam ecosystem or connected systems. Eg. RDBMS
  • AI-Generated Code/Logic: For more complex or custom requirements, users can describe the desired logic in natural language. Ekyam’s AI can then assist in generating the underlying code or workflow steps needed to implement that logic. The user can review and refine this AI-generated logic. Eg. Custom operations
  • Predictive Analytics Integration: Workflows can trigger or be triggered by AI models, for example, to predict fraudulent orders, forecast demand based on incoming sales data, or personalize product recommendations.
Let us explain the above using a Use Case of where the NetSuite data needs to be pushed to Shopify (NetSuite Shopify Products Sync):  Source: Net Suite ; Destination: Shopify To show the different types of Sync in this Data flow, the user can click:  Order Sync, Inventory Sync, Products Sync , Shipment Sync and Data Sync.  For applying Business Logic, the user can choose different fields: 
A user can choose multiple functions to create a workflow.
Workflow Representation: The below screenshot shows the Products Sync between NetSuite and Shopify. Group2085666898.png String Operations When a user selects String Operation, below is the screen that will appear.   Group20856.png Mathematical Functions On selecting the Mathematical functions, below screen is visible: num.png Date Operations The user can select the Date Operations as shown below: data.png RDBMS functions On selecting the RDBMS Operations: The user will be able to see a User Prompt and Aggregation text box. The user can write the prompt in it to generate an Aggregation. daxa.png Custom Operations When the user selects Custom Operations, they can add a User prompt to generate a Code snippet. vdv.png
⌘I