Getting Started with DataBridge: Web-Based Tool for Structured Data Migration

Getting Started with DataBridge: Web-Based Tool for Structured Data Migration

Overview

DataBridge(Aplus Inflow) is a web-based tool designed for structured data migration between systems. It is tailored for batch and automated migration scenarios. It runs as a standalone on-premise application, deployed on Apache Tomcat and using PostgreSQL as its backend. The frontend is built using Vue.js and authentication is handled via Basic Auth.

Quote
Version: 1.0
Type: On-Premise Deployment

High-Level Architecture 

The architecture comprises the following components:
  1. Source System(s) and Target System(s) for data exchange.
  2. Aplus Inflow Web Application for managing the migration logic.
  3. Apache Tomcat is the application server.
  4. PostgreSQL as the backend database


Components

  1.  Web Interface: Built using Vue.js, allows users to configure and manage migration jobs.
  2.  Core Migration Engine: Executes configured API requests, handles responses, supports transformations and scheduling.
  3.  API Handler Module: Uses Apache HttpClient for sending API requests and handling authentication.
  4.  PostgreSQL Database: Stores job configurations, execution logs, metadata, and user information

DataBridge – Basic Requirements

  1. Operating System: A machine with Windows or Linux (Ubuntu/CentOS) installed.
  2. Memory: Minimum 8 GB RAM for optimal performance.
  3. Storage: Up to 200 GB of hard disk space.
  4. Browser: Chrome or Edge (only these are currently supported).
  5. Network: Port 8445 must be open to enable communication with the API tool. 
    Info
    For AnalyticsPlus Cloud, the URLs https://AnalyticsPlus.manageengine.com and https://accounts.zoho.com (or .eu, based on the AnalyticsPlus data center) must be accessible from the server where the agent is installed.

Registering Inflow as a service in Windows Machine

  1.  Extract the Agent.zip file to the desired location.
    (Note: This agent file will be provided based on the tool from which data is being fetched. Please contact Analytics Plus support to obtain the appropriate file.)
  2. Open command prompt (Run as Administrator ) and navigate to <Agent home>/bin directory.
  3. Run the script "InstallService.bat".
  4. In case the port 8445 is occupied, please navigate to <Agent home>/bin directory and execute the script "ChangeHostPort.bat <Desired Port Number>".
  5. Start the service(Aplus Inflow) in "services.msc".
  6. Access the application using https://localhost:8445(Default Port)  in the browser.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Sync getting stuck in In-progress state

                      Issue:  Sync getting stuck in In-progress state. Usually, when the data type mismatch is present, this issue occurs. Logs required: <AnalyticsPlus>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR:  invalid input syntax for" Sample ...
                    • Imported data in a column shows an incorrect value

                      Issue: In Analytics Plus version 4100, when a data is imported into Analytics Plus(especially from MSSQL server), a few column values are not identified properly.  The query used to pull the details works fine on MSSQL server and returns proper ...
                    • Filters getting duplicated when reports are saved and reopened

                      This issue is seen in Analytics Plus build 3800.  Issue: When a filter is added/edited to a report and saved, the report shows up fine. But, when we close and reopen the report, the filter gets duplicated and causes issues in loading the right data. ...
                    • Problem Module Data import

                      Importing Problem data into Analytics Plus:  You could log into the Analytics Plus 'ME ServiceDesk Plus Analytics' database and start creating these two tables using the below queries. Check this link for steps to import data from Local DB. Problem ...
                    • OPM reports dealing with performance data shows No Data

                      Issue: It seems that OPM reports dealing with performance data are having issues where it displays no data. The problem is present for reports which has Attribute added in the filter.  Cause: The name change of the attributes used in the filter is ...