Data Migration Services
Written By Elliot Atherley

Mission Statement

Our client asked us for assistance in decommissioning their TaskForce Instance, with the proviso that they still needed access to generate a limited number of reports.

Our recommended solution was to use Alteryx to migrate the data onto an SQL Server and recreate the required reporting from the SQL Server utilising Alteryx.

Tools Used

  • Alteryx Designer

  • Firebird ODBC Drivers

  • SQL Database

Detailed Solution

The following process was followed:

  • Connect to the TaskForce database using Firebird ODBC drivers.

  • Extract all tables with data into Alteryx Database files to maintain all data types.

  • Create a SQL Database to house the new data.

  • Use a macro created by me (David Johnson) in Alteryx to read all the tables individually and create the tables in the SQL Database and to load the data at the same time.

  • Recreate the required report using Alteryx and information gathered from the Stored Procedures in the Firebird database.

Elliot Atherley
Previous
Next