Understand and create test data

This section provides an overview of the different types of data that you work with in Decision Insight, and how to create some test data for the Order entity.

1. Data types

Decision Insight distinguishes two types of data, which are managed differently:

  • static data – data that you want to define but that does not change much.
  • transaction data  – data about the items that are moving through the DI workflow; transaction data changes frequently.

Static data

In almost every business solution, some data is not liable to change very often. It is still considered data – something you want to define and access rather than build into the solution – because it is on the business side of the boundary between the process and the monitoring solution. This is static data. You can use static data to translate internal nomenclature into human-factored information. 

Static data is usually only read by the solution at start-up, or when a refresh is initiated manually.

Example

For example, an insurance claim process might use EDI message types of 270, 271, 276 and 277. Your solution could use those numbers and some people would understand what they are seeing; others might not. To accommodate both user types, your dashboards could use labels for messages that would read:

  • Benefit Inquiry (270)
  • Benefit Response (271)
  • Claim Status Request (276)
  • Claim Status Notification (277)

The definitions for EDI messages are not likely to change, which is why they are considered static. Over time, additional message types might be included into the deployment, so you want to allow for new message type definitions to be added easily into the system.

Transaction data

The other type of data is transaction data. For flow-based business processes, transaction data represents information about the operations of the business process itself, for example, information about a file or a transaction that is changing state or location. This information can be the result of pulling data into or pushing data toward the solution.

 Transaction data inherently represents current information that is updated as time goes by. 

Apache Camel for data access

To manage data access, Axway Decision Insight uses the Apache Camel open-source java framework . Camel is a rule-based routing and mediation engine that is bundled into each Decision Insight deployment.

For the tech savvy, take a look at Integration with Apache Camel by Jonathan Anstey. You can find that article at https://dzone.com/articles/open-source-integration-apache.

If you are not tech savvy, Camel helps connect Decision Insight to the external information it needs to run your application. That information can be in a messaging application, a database, a log file, or essentially any file that contains data you need. In this exercise, you will link to static data and a comma separated value (csv) file.

2. Create the test data

The test data set starts small. The idea is to test the logic of your route to verify it is working before attempting to manage a larger volume of information. The data you need will contain only one type of event. As a reminder, the process events are:

Process Step Events Generated
Purchase Orders Received New Order

Validation

Order

Valid Order

Review

Invalid Order

Scheduler Line Request Scheduled
Production Line Line Request Completed
Shipping

Logistics Order

ASN

Shipped

Purchase Order Invoicing Invoiced
Receivables Payment Received

For the initial test data, you need the New Order event.

Create a resource

To create a resource for the Order entity, follow these steps.

Step Action
1

On the main menu, click the Data Integration icon.

2 On the left menu, click Resources. The Resources pane is displayed.
3

From the In space drop-down box, select the Initializers space. This is the space in which you want to create your resource.

4

Click New Resource. The Details pane is displayed.

5 Give the resource a Name. For names, it is recommended to use the camel case convention and give your resources relevant names.
Because you are creating a resource for orders, prefix the word order with the first three letters in the word resource to name the resource resOrder
6 Leave the Type and Charset fields as is. In this tutorial, you are creating a text resource in UTF-8 encoding.
7

In the Content text box, enter the following text, which corresponds to the Kabels log file:


Application creation date

Important: Because you set your application creation date to the first day of the previous month, you can only import data that is dated after that creation date. This means you may need to modify the timestamp of the orders in the log file below, depending on when you start following this tutorial.

Timestamp|CustomerName|CustomerReference|CycleNumber
2016-12-01T14:24:14|Utensil Systems|9558RQ|16040022
2016-12-01T14:36:38|Springbok Space | ORDN051|16040023
2016-12-01T14:49:02|Triangle Technologies|1711|16040024
2016-12-01T15:01:26|Triangle Technologies|1711.1|16040025

Note: The first line of text provides heading names for the different types of data. We will define the following entities: Timestamp, CustomerName, CustomerReference, and CycleNumber.

8 Check your data. If you're satisfied, click Save.

Tip: Click the icon in the Details pane to copy the link to the resource you just created to your clipboard. You will need it for the next part of this tutorial.

Related Links