Analytics Exchange to Robots migration guide

This guide explains how to migrate from Analytics Exchange (AX) to the Robots app in the Diligent One Platform. The guide covers setting up the necessary structure in Robots, migrating scripts and data, recreating automated AX processes in Robots, and post-migration activities. It also summarizes the benefits of migrating.

Migrating from AX to Robots requires a number of steps, but if you follow the guide the overall process is not difficult.

View this guide as a PDF

Who is this guide for?

This guide assumes your organization currently uses Analytics Exchange for running automated data analysis processes and that you are ready to migrate those processes to the Robots app in the Diligent One Platform. The guide also provides valuable information for organizations that are considering migrating.

The guide assumes that you are going to use an on-premise Robots Agent to analyze and process data on your own network rather than use the option of a cloud-based Robots Agent. Using a cloud-based agent is not practical for most, if not all, existing AX customers.

For more information about the considerations involved with migrating, see Additional information about migrating from AX to Robots.

Performing the migration: our recommended approach

  1. Before you start the migration, you must complete the prerequisite tasks and activities explained in Prerequisites (before you start the migration).
  2. Once the prerequisites are in place, we recommend performing the migration in four stages:
    1. Recreate your AX repository structure in Robots
    2. Migrate the scripts
    3. Migrate the data
    4. Recreate automated AX processes in Robots
  3. After completing the migration, review Post-migration activities and perform post-migration tasks as required.

Quickly familiarize with the end-to-end process

The main steps in the end-to-end migration process are outlined below. Some of the steps may not apply to your organization, depending on how you have set up automated processes in AX.

Migration stage Steps Applies to:
Recreate your AX repository structure in Robots

Create empty robots in the Robots app in Diligent One.

A robot is a container that houses uploaded analytic scripts, any Analytics data tables, and any related files. The robot is the object that you configure to carry out scheduled, automated tasks.

All organizations
Migrate the scripts Export your organization's analytic scripts from AX to an intermediary location All organizations
Configure scripts to replicate AX analytic chains in Robots Organizations that use analytic chains in AX
Commit (upload) the scripts to an appropriate robot in Robots All organizations
Migrate the data If Analytics data tables in AX do not contain historical data, recreate the tables in Robots Organizations that use Analytics data tables in AX (tables created with the //DATA tag)
If Analytics data tables in AX contain historical data that you need to retain, use the Diligent migration scripts to migrate the tables from AX to Robots Organizations that use Analytics data tables in AX (tables created with the //DATA tag)
Upload or migrate non-Analytics related files Organizations that use non-Analytics related files in AX (files contained in Related Files folders)
Recreate automated AX processes in Robots Re-link tables using shared and linked tables in Robots Organizations that use master and linked tables in AX

Set up automated processes in Robots:

  1. In development mode, create a robot task for each automated process.
  2. Test a task by running it ad hoc.
  3. Once a task is running correctly, activate the scripts to production.
  4. In production, create and schedule a robot task for the automated process.
All organizations

Take an iterative approach

We also recommend that you take an iterative approach to the migration, especially if your organization has a large number of automated processes currently running in AX:

  • Run in parallel Run AX and Robots in parallel for a period of time.
  • Pilot the migration Pilot the migration by initially replicating in Robots only one or two automated processes. Recreate the structure, and migrate the scripts and data, for only this limited number of processes.
  • Compare output results Compare the output results from the same processes running in AX and Robots. Once you are satisfied that the initial processes are working correctly in Robots, you can recreate the structure, and migrate the scripts and data, for the remainder of your automated processes.

Prerequisites (before you start the migration)

In preparation for the migration, you must complete several tasks and activities.

Task/Activity Details

Required

Verify your ACL Robotics subscription and permissions

Work with your Diligent account representative to make sure that your organization has the correct type of ACL Robotics subscription, with enough licenses for all your intended users.

  • Required ACL Robotics edition: Enterprise

    Note

    Because of functional restrictions, ACL Robotics Professional Edition is not suited as a replacement for AX.

Make sure that you have the Diligent One administrator permissions required to perform the migration:

  • Launchpad user type: System Admin
  • Subscription: Professional

Note

The assumption is that you are also an AX Server administrator.

Required

Confirm your Launchpad and Robots administrator access

Once the ACL Robotics subscription and permissions are in place, sign in to Diligent One, and make sure you can access the following admin-only locations:

  • In Launchpad, the page for adding and managing Diligent One users: Platform Settings > Users
  • In Robots, the global settings:
    • Settings > Agent management
    • Settings > User management

Required

Provision an additional Windows server

Provision an additional Windows server for your network.

The additional Windows server is for installing an on-premise Robots Agent, the data processing component of Robots.

For server and operating system requirements, see On-premise Robots Agent system requirements.

If you intend to use multiple on-premise agents for increased processing capacity and load-balancing, you need to provision an additional Windows server for each additional Robots Agent. You can choose to perform this portion of the migration later, after you have successfully migrated automated processes from AX to the first Robots Agent server. If your organization currently uses additional servers for AX Engine Node, you can probably repurpose those servers for installation of additional instances of the Robots Agent.

Caution

Do not install the Robots Agent on the same Windows server as AX Server. Resource conflicts and unexpected behavior can occur and troubleshooting can be difficult.

Required

Install the Robots Agent on the Windows server

Install and configure the on-premise Robots Agent by following the instructions in these topics:

  1. On-premise Robots Agent security
  2. Installing or upgrading an on-premise Robots Agent
  3. Character encoding used by the Robots Agent
  4. Configuring an on-premise Robots Agent
Optional

Install one or more additional instances of the Robots Agent on one or more additional Windows servers

Use the same process that you used for installing the first instance of the Robots Agent.

For more information, see Install an additional instance of the Robots Agent.

Tip

Focus on installing a single Robots Agent on a single server first. Once this first installation is operating successfully, you can set up a multi-agent cluster.

Strongly recommended

Confirm that the on-premise Robots Agent is working

See Test the Robots Agent.

Required, if applicable

Install Direct Link on the server where the Robots Agent is installed

If you have been using Direct Link with AX to access SAP data, do one of the following:

  • Install Direct Link to work with the Robots Agent
  • Transition to using the ACL Connector for SAP (the SAP Connector) instead of Direct Link

    See Connecting to SAP.

Note

If you take an iterative approach to the migration, and some of your automated processes do not require importing SAP data, you could install Direct Link as a post-migration task.

Strongly recommended

Familiarize with the Robots app

The migration will go more smoothly if you first take the time to familiarize with the Robots user interface and the workflow.

The easiest way to get familiar with Robots is to do the lightweight tutorial: Getting started with ACL Robotics.