Overview

A light integrator capable of calling APIs, storing data, ETL creation with variety of connectors for business needs.

• Hosted on local server, powered by CloudFlare, orchestered by Docker.
• Various connectors for making API calls and storing responses in database (currently supports only SQL Server).
• Has an inbuilt AI Chatbot to answer queries about the product.
• Quickly setup your job and job steps and then it can be run on demand or on a schedule.
• List of current connectors:
  • APCFetch - Takes API call details and Database details from frontend and stores the response.
  • APCPush - Takes the API details from a database table, makes the network call and stores the response.
  • ResponseParser - Parses the raw JSON into tabular data, supports many common parsing ways like Unifier UDR, P6 responses and a generic parser which can parse any JSON.
  • ProcedureExecutor - Can execute a stored procedure in an Oracle DB or SQL Server.
  • P6Extractor - Extracts common methods of P6 like Projects, Activities, Resources, Calendar etc into an excel extract or into a database.
  • FileMovement - Ability to move files from/to Network File Share or SFTP.
  • UnifierExtractor - Extacts, parses and stores data from Unifier UDR into a database.
  • ZipFileExtractor - Extracts zip file from a base64 and downloads the files inside it.