How to Transfer Any Source Data to Kafka

How to Transfer Any Source Data to Kafka

Open Automation Software aggregates data from any number of sources in one place. Each Tag carries its own Data Source, so a Tag can be read by any of the OAS Drivers, set directly as a Value Tag by hand or from your own application through the OAS Data API, or derived in real time by a Calculation Tag built from one or more other Tags no matter where those Tags get their own values.

Whatever mix of sources you use, the resulting Tags can be transferred together to a Kafka cluster.

This guide walks you through downloading and installing OAS, creating a Tag, assigning its Data Source, and configuring a Kafka connector and publishing the Tag.

For this guide on how to transfer any source data to Kafka you will need:

  • A data source for your Tags, such as a device, broker or database reachable by one of the OAS Drivers. Value Tags and Calculation Tags need no external source.
  • Docker installed in Linux or Windows including the docker-compose utility

1 - Download and Install OAS

If you have not already done so, you will need to download and install the OAS platform.

Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.

On Windows, run the downloaded setup.exe file to install the Open Automation Software platform. For a default installation, Agree to the End User License Agreement and then click the Next button on each of the installation steps until it has completed.

If you'd like to customize your installation or learn more, use the following instructions:

The OAS Service Control application will appear when the installation finishes on Windows.

OAS Service Control

Click on each START SERVICE button to start each of the three OAS services.

2 - Configure OAS

Web Configuration Application

Configuration of the OAS server is performed from the built-in Web Configuration Application. This is the main application for accessing any settings within the OAS server and is completely self-contained within the server.

OAS Logo

You can reach this by opening your browser to:

http://<your server>:58725/app/config

If you are browsing from the OAS machine itself, you can use localhost, otherwise use the IP address of the machine. You will also need to ensure port 58725 is open on both the client and the server or you may not be able to reach the application.

On a new installation the OAS engine has no accounts yet, so the first screen you see is Create Admin Account. Once the administrator account exists that screen is not shown again, and browsing to the application displays the sign in screen instead.

Create Admin Account

OAS Web Config Login

  1. Enter a name for the administrator in the Admin user name field. Typically you would use admin, but you can use whatever name you choose.

  2. Enter a password in the Password field, then enter the same password again in the Confirm password field.

  3. Click on the Create admin & sign in button. The account is created and you are signed in to the engine.

Warning

Write these credentials down and keep them safe. There is no automated password recovery. If they are lost, the administrator must be restored on the server itself.

To sign in from then on, enter the Network node of the OAS engine, then the Username and Password of your account, and click on the Sign in button.

Info

In this guide you will use the Web Configuration Application to configure the local Node which by default is localhost.

If you have installed OAS on a remote instance you can also connect to the remote instance by setting the relevant IP address or host name in the Node field.

Important

Eventually the Legacy Desktop Configuration Application will be retired, but it is currently still available and shipped with the OAS product installation. If you choose to use it, instructions for accessing it are below. Documentation in the Knowledge Base will be replaced with the Web Application when it is retired.

Legacy Configuration Application

  1. From your operating system start menu, open the Configure OAS application.

  2. Select the Configure > Tags screen.

    Important

    If this is the first time you have installed OAS, the AdminCreate utility will run when you select a screen in the Configure menu. This will ask you to create a username and password for the admin user. This user will have full permissions in the OAS platform.

    For further information see Getting Started - Security.

  3. If this is the first time you are logging in, you will see the AdminCreate utility. Follow the prompts to set up your admin account. Otherwise, select the Log In menu button and provide the Network Node, username and password.

    Log In Menu

    Log In Dialog

3 - Create a Kafka test cluster using Docker

In this step you will create a local Kafka cluster. To simplify the deployment you will need to have Docker installed including the docker-compose utility. This method allows you to create a cluster very quickly for testing purposes and remove it again when you are done.

  1. Create a new folder such as Kafka and inside the folder create a new docker-compose.yml file with the following definition.

    services:
        zookeeper:
            image: confluentinc/cp-zookeeper:latest
            container_name: zookeeper
            ports:
                - "2181:2181"
            environment:
            ZOOKEEPER_CLIENT_PORT: 2181
            ZOOKEEPER_TICK_TIME: 2000
    
        kafka:
            image: confluentinc/cp-kafka:latest
            container_name: kafka
            ports:
                - "9092:9092"
            environment:
            KAFKA_BROKER_ID: 1
            KAFKA_ZOOKEEPER_CONNECT: zookeeper:2181
            KAFKA_ADVERTISED_LISTENERS: PLAINTEXT://localhost:9092
            KAFKA_LISTENER_SECURITY_PROTOCOL_MAP: PLAINTEXT:PLAINTEXT
            KAFKA_OFFSETS_TOPIC_REPLICATION_FACTOR: 1
    
    
  2. Open a command line or bash terminal in the Kafka folder and use the following command to start a new container. This will download the image and all its dependencies and may take a few minutes.

    docker-compose up -d

  3. Create a new topic called temperature using the following command.

    docker exec kafka kafka-topics --create --topic temperature --bootstrap-server localhost:9092 --partitions 1 --replication-factor 1


Info

Once you are done testing, you can stop and remove the containers that you created by using the following command:

docker-compose down

4 - Add Data Source Tag

In this section you will create a Tag to represent your data point in the field (for example a temperature sensor). This can then be transferred your desired destination.

  1. In the sidebar menu, select Tags.

    Configure tags menu

  2. If you want to add a Tag to the root Tags group make sure another tag at the root is selected. Click the [+] button and select Add Tag.

    Add tag button

    If you want to add a Tag to a Tag Group, select the Tag Group first and then click on the [+] button. Alternatively, you can right click on a Tag Group and select Add Tag.

    You can also add Tag Groups by clicking the [+] and selecting Add Group.

  3. Provide a Tag Name such as TemperatureSensor and click the Create button.

    Add tag to root node dialog

5 - Assign the Tag Data Source

Every Tag in OAS carries its own Data Source, which is what makes aggregation possible. One OAS instance can hold Tags fed by a PLC, a cloud broker, a database and a calculation all at the same time, and everything downstream works from the Tag list rather than from the driver. That is why a single logging group or a single publish list can carry values that arrived from completely different places.

You will now set the Data Source of the Tag you created in the previous section.

  1. Select the TemperatureSensor Tag.

    Tag

  2. Set the Data Source to whichever source supplies this Tag. Any of the following can drive it:

    • A driver. Set the Data Source to the driver you want to read from, then set the Select Driver Interface drop-down to the driver interface you configured, and complete the addressing properties for that driver. The Drivers section describes every driver, what it supports and how to configure it.

    • Value. Set the Data Source to Value for a Tag whose value is written to it rather than polled from a device. You can set it by hand in the Web Configuration Application, or write to it from your own application with the OAS Data API. Setpoints, recipe values, operator entries and values pushed in from an external system are all handled this way.

    • Calculation. Set the Data Source to Calculation to derive the value from other Tags. A Calculation Tag is evaluated in real time whenever any Tag it references changes, and it can reference one or more Tags regardless of what their own Data Sources are. This lets you convert units, scale raw counts, roll several machines up into one figure, or combine a device reading with a value that came from the cloud, before any of it is logged or transferred. See How to Create a Calculation Tag for a worked example, and the Calculations reference for the full function list.

  3. Complete the remaining properties for the Data Source you selected. Driver Tags also have a Polling Rate property that sets how often the value is read, in seconds [default: 1 second].

  4. Click on the Apply changes button to apply the changes.

  5. Check that the quality status is Good and the Tag value is as expected.

    Tag quality

Tips

Repeat the previous section and this one for every Tag you want to include. The Tags can use any mix of the sources above, and the remaining steps in this guide are the same whichever combination you choose.

6 - Configure Kafka Producer

In the following steps you will create and configure a Kafka Connector connecting to a local Kafka cluster on port 9092. This connector will act as a Producer where Tags are published to a topic in the cluster.

  1. Select Drivers in the sidebar.

  2. Click + Add, enter a meaningful Driver Interface Name to give this driver interface instance a unique name (for example Kafka Producer), and click Create. Once created, the driver interface name should appear in the list of drivers.

  3. Ensure the following parameters are configured:

    • Driver: Kafka
    • Bootstrap Servers: localhost:9092
    • Security Protocol: Plaintext
    • Client Id: oas-kafka-producer

    Kafka producer configuration

    The app flags the Bootstrap Servers field because it is still the default localhost:9092. That is the address of the local test cluster you created, so leave it as it is. Change it if your broker is on another host or port.

  4. Turn on Enable and click on the Apply changes button. The driver interface is not active until it is enabled and the changes are applied.

    Apply changes button

7 - Publish Selected Tags in Kafka Producer

In this step you will select the Tags that you want to publish to the Kafka cluster.

  1. In the Drivers screen, select the Kafka driver instance that you created in the previous section (for example Kafka Producer).

  2. Make sure the Publish Selected Tags toggle is turned on.

    Publish selected tags

  3. In the Tags To Publish table click on the Add button.

    Publish selected tags Add button

  4. The Publish tag window will appear. Click on the button to browse for a Tag, select the Tag you want to add in the left hand panel and then ensure the Value property is selected, and click on the Use this tag button.

    Tag browser

  5. Back in the Publish tag window the Id defaults to the full Tag path (e.g. TemperatureSensor.Value). If you want to set your own property name, you can change the Id field to your own custom value. Click on the OK button.

    Publish tag window

  6. The Tag has now been added to the list. You can add other Tags by repeating steps 3 to 5.

    Tag browser

  7. Click on the Apply changes button.

8 - Verify Messages are Published to Kafka Cluster

In this step you will confirm that OAS is successfully publishing your selected Tags to the Kafka cluster.

  1. Run the following command in a terminal or command line window to start listening for new messages on the oas_tags topic which is the default topic for the Publish Selected Tags configuration.

    docker exec kafka kafka-console-consumer --topic oas_tags --bootstrap-server localhost:9092
    

    Info

    You may receive a warning message, because the oas_tags topic doesn't exist yet. You can safely ignore this as it will be created automatically.

  2. Any changes your TemperatureSensor tag value should be published within 10 seconds to the terminal window.

    {
        "values": [
            {
                "id": "TemperatureSensor",
                "value": 24.902344,
                "quality": true,
                "timestamp": "2025-05-20T09:23:41.332Z"
            }
        ]
    }
    
  3. To stop listening for new messages press the Ctrl-C shortcut combination on your keyboard.

9 - Save Changes

Once you have successfully configured your OAS instances, make sure you save your configuration.

On each configuration page that has a Save button, click on it.

If this is the first time you are saving the configuration, or if you are changing the name of the configuration file, OAS will ask you if you want to change the default configuration file.

If you select Yes then OAS will make this configuration file the default and if the OAS service is restarted then this file will be loaded on start-up.

If you select No then OAS will still save your configuration file, but it will not be the default file that is loaded on start-up.

Important

Each configuration screen has an independent configuration file except for the Tags and Drivers configurations, which share the same configuration file. It is still important to click on the Save button whenever you make any changes on those screens.

The Security, Users and Options screens have no Save button. Changes you make there are written to disk as soon as you make them, so there is nothing further to save.

For more information see: Save and Load Configuration

Info

  • On Windows the configuration files are stored in C:\ProgramData\OpenAutomationSoftware\ConfigFiles.
  • On Linux the configuration files are stored in the ConfigFiles subfolder of the OAS installation path.

Ready to get started?

See how OAS fits your environment, or get pricing for your project.