Skip to content

Redis Data Mapping

Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow, certain attributes of your trigger application are available to the Action application for data mapping while making API calls.

These attributes can be mapped to the specific attributes of the Action application. This powerful capability not only allows field mapping but it also allows complex transformation using excel style functions to apply hundreds of formulas and operations. The choice of excel style function makes data mapping on Connect iPaaS easy for business users who are already well versed with Microsoft Excel formulas.

Example Scenario with Redis trigger

In the example workflow shown below, Redis is the trigger application. You can access the following attribute of the Redis event in any of the application actions while designing your workflow.

  • Port - You have to enter the port number where the database is running.
  • Database - Database used to store the data. Redis provides 0-15 indexes for databases. By default, it is 0.
  • Operation On - The Redis data type on which the event has been performed. (For example:- String, Lists, etc.)
  • Host - Host is the name of the server that hosts your database. You can setup hostname by IP Address and DNS. When you use an IP-based connection option, you can simply connect using the port number. (For example:- The port number is 6379. The IP address for it can be like 10.0.0.12:6379). When you use DNS as an option, you need to have your domain (For example, mydomain.com).
  • Operation Type - Operation type is the number of operations for manipulating special cases of particular types (For example, HSET).
  • Operation Result - Operation Result is the value returned from the Redis Command.

Data Mapping on Redis application

Figure 1. Data Mapping on Redis Application

As shown in figure 1 above, we are mapping parameters from the Redis "Get Data for Sorted Sets" trigger to Outlook for Sending a Message. We can access the values of table Matric Result based on the data attributes of the Redis Trigger. In this example, the value of Operation Result from the Redis application is mapped in the Message of Outlook application. We are also using Date & Time functions - TODAY() to show the current day in the Subject Content.

As shown in figure 1 above, we are mapping parameters from the Redis "Get Data for Sorted Sets" trigger to Outlook for Sending a Message. In this example, The value of Operation Result from the Redis application is mapped in the Message of Outlook application. We are also using Date & Time functions - TODAY() to show the current day in the Subject Content.