TechVariable developed a connector engine, making it possible to extract customizable user-defined data from any data source. The connector supports the OData sources, including Microsoft Azure, SharePoint, Office 365, Salesforce, and Tableau. It also allows data extraction from non-OData sources like JIRA, REST, and SOAP APIs. The extracted data is then brought to the connector/adapter store based on the user inputs.
Industry: Technology
Development of Efficient Connector Engine for Effective Insights
0
Engineers
0
Months
0%
Reduction in operation cost
Services
Product Engineering
Technology
JAVA Springboot, Grakn, Apache ODATA Olingo library, Angular, Mongo DB, Node.js
Location
Malaysia
Interested?
Overview
Challenges
The client is an HR tech giant that provides its customers with Key Performance Indicators (KPIs). Their customers used disparate, unconnected off-the-shelf applications for various business functions. It prevented them from generating meaningful, organization-wide KPIs. Difficulties in curating the data from such disparate sources hampered any Business Intelligence (BI) operations challenging.
Solutions
TechVariable developed a connector engine, making it possible to extract customizable user-defined data from any data source. The connector supports the OData sources, including Microsoft Azure, SharePoint, Office 365, Salesforce, and Tableau. It also allows data extraction from non-OData sources like JIRA, REST, and SOAP APIs. The extracted data is then brought to the connector/adapter store based on the user-inputs.
The connector would fetch details of available data based on the application chosen by the user. The user can then select the data types required for analysis. The connector then injects the data into the BI pipeline to extract valuable insights in the form of KPIs.
High Level Design Architecture
The Result
1. The customers can now pull data from multiple, disjointed data sources to generate meaningful, holistic insights and KPIs.
2. The automation through schedulers and data push to BI systems increases the efficiency of the KPI generation.
Modules Implemented
Data Publishing for Downstream System
The connector pushes extracted data to the downstream BI pipeline for further processing, analysis, and insights generation.
AI-based Schema Generation
Using Grakn, the connector generates the schema using the metadata specified by the user.
Meta Data Extraction Module
Once the user defines the data source for extraction, the connector extract metadata. Users can select the exact information they require from this metadata.
Scheduler or Incremental Fetch
A schedule can be set, and the connector extracts the data automatically at predefined periods.
Case Studies
Our team has worked on projects across domains
Industry: Fin - Tech
Smart Recon – A SAAS financial reconciliation process
A SAAS automate tedious financial reconciliation processes. We built an independent, fully integrated app that automated the process of identifying mismatches between large sets of accounting data, and simplified the management of these exceptions......
0
Engineers
0
Months
0%
Reduction in operation cost
Services :
Rapid Application Development, Product Engineering, Data Infrastructure Modernization
Technology :
Python, React.js, MongoDB, PostgreSQL
Industry: Technology
TechVariable digitally transforms an MNC’s remuneration management system across 30 countries
A US-based Fortune 200 company that employs around 91,000 people across 30 countries. The company did not have a reliable system for compensation management and relied on Microsoft Excel and email for the entire exercise.
0
Engineers
0
Months
0%
Reduction in operation cost
Services :
Product Engineering, Application Modernization, Data Infrastructure Modernization
Technology :
Reactjs, Nodejs, GraphQL, stored procedures on MySQL, Microsoft Azure
Industry: Technology
Optimizing Customer Relationship Management With a Custom Solution
The system registers companies with company specific details and service or packages opted. Services are of two type – onetime and recurring. A company may opt for a single service or a package containing multiple services. Based on the opted services, employees at Vaasist manage tasks and enquiries. Task and enquiries get auto generated on monthly basis, based on their frequency.
0
Engineers
0
Months
0%
Reduction in operation cost
Services :
Rapid Prototyping, Rapid Application Development
Technology :
Node.Js, React.Js, MongoDB, Apache
Industry: Travel and Hospitality
Digital Transformation of North East India’s largest private transport services
The end-to-end solution comprises an Android App for the customers, a web interface for the offline counters, and an admin panel for managing the operations.
0
Engineers
0
Months
0%
Reduction in operation cost
Services :
Product Conceptualization, Rapid Prototyping, Custom Application Development
Technology :
JAVA Spring Boot, React.js, Android Studio, Open Shift, AWS
Industry: Healthcare
An application for care gap management amongst the underserved communities
The project was developed for a Federally Qualified Health Center (FQHC) in Chicago, which receive financial aid from the government. Received funds are managed by third-party insurance companies, and FQHCs are required to report on their performance.
0
Engineers
0
Months
0%
Reduction in operation cost
Services :
Rapid Application Development, Product Engineering, Data Infrastructure Modernization
Technology :
AWS Neptune, React.js, Node.js, Lambda Functions, PostgreSQL, Snowflake
