Automated Onboarding via ERP API and OCR Data Extraction

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Businesses face inefficiencies and increased costs when transitioning between disparate software platforms, such as ERP and CRM systems, due to fragmentation, requiring manual data input and lengthy onboarding processes.

Innovation Solution

An institution computing system (ICS) facilitates automated onboarding by leveraging APIs to pull data from enterprise resources, utilizing OCR engines and machine learning models to optimize datasets and reduce manual intervention, thereby accelerating the onboarding process and minimizing data sharing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If manual data input and traditional onboarding processes are used to establish new accounts between software platforms, then data accuracy can be maintained through verification, but time consumption and operational costs increase significantly

Engineering Contradiction:

Improvedata accuracyVSAvoidonboarding time

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The patent replaces manual mechanical data entry processes with automated optical character recognition (OCR) technology and application programming interfaces (APIs). The system captures data from source documents using OCR, validates it through structured fields, and transfers it automatically between ERP and CRM platforms, eliminating manual typing while maintaining accuracy through validation rules.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The system enables self-service account establishment by automatically gathering required data from existing enterprise systems through APIs, validating data through predefined rules, and creating accounts without human intervention. The automated workflow includes self-validation of data formats, self-routing of account types, and self-completion of onboarding processes.

Inventive Principle:

Principle #25Self-service

2Loss of information

If comprehensive data collection is performed during onboarding to ensure complete account information, then data completeness is improved, but data storage requirements and processing complexity increase

Engineering Contradiction:

Improvedata completenessVSAvoidsystem complexity

Core Design Contradiction:

Loss of informationVSDevice complexity

Solution Approach 1:

The patent segments the onboarding data collection process into distinct modular components: identity verification module, business information module, financial data module, and compliance documentation module. Each module handles specific data types independently, allowing comprehensive data collection while maintaining manageable system complexity through clear separation of concerns.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The system introduces an intermediary data validation and routing layer that sits between data collection and storage. This intermediary automatically validates incoming data against predefined schemas, routes data to appropriate storage locations, and manages data relationships, thereby ensuring completeness without proportionally increasing overall system complexity.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If automated data collection through APIs and OCR is implemented to reduce manual input, then onboarding efficiency is improved, but system integration complexity and initial setup requirements increase

Engineering Contradiction:

Improveonboarding efficiencyVSAvoidintegration complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent implements a universal data collection framework that uses standardized APIs and OCR technology to interface with multiple different source systems (ERP platforms, document management systems, third-party services). This universal approach allows the same automated collection mechanisms to work across diverse systems, improving efficiency while managing integration complexity through standardization.

Inventive Principle:

Principle #6Universality (Multi-functionality)

4Reliability

If extensive user verification and data validation are performed during account creation, then account security and data quality are improved, but processing time and operational steps increase

Engineering Contradiction:

Improveaccount securityVSAvoidverification time

Core Design Contradiction:

ReliabilityVSDuration of action of moving object

Solution Approach 1:

The system performs preliminary data validation and verification checks during the data collection phase itself, rather than as separate subsequent steps. Validation rules are applied immediately when data is captured, ensuring security and quality requirements are met upfront, which reduces overall processing time by eliminating redundant later verification steps.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS20240403887A1Systems and methods for digital onboarding using ERP data

Publication Date: 2024.12.05 WELLS FARGO BANK NA

AI summary

Systems and methods for establishing a connection between a first computing system and a first application hosted on one or more remote servers may include receiving, from a computing device, a request to establish a new account with the first computing system, determining a dataset for establishing the new account with the first computing system, the dataset including a first data entry and a second data entry, polling one or more servers of the first computing system for first data to satisfy the first data entry, transmitting a query via the connection to an application program interface (API) for the first application for second data to satisfy the second entry, and establishing the new account with the first computing system based on the first data and the second data.