ETL Connector

Bridge your business applications and content management

Ingress ETL Connector is integration middleware and an Extract, Transformation & Load (ETL) tool, all in one! It seamlessly integrates your corporate business applications to OpenText Content Manager, automating recordkeeping and enhancing access within your business applications.

Integration

Effortlessly bridge your transactional business systems and Content Manager. Ingress Connector embeds robust recordkeeping into all systems, automating documentation during critical decision-making stages.

Efficiency

Reduce risks, costs, and maintenance efforts. With its loose coupling approach, Ingress Connector allows for easy modifications, upgrades, or additions to your systems without incurring significant costs.

Reliability

Depend on a tried and tested solution that simplifies maintaining integrations over time. Easy to install and set up, it delivers fast, cost-effective results, enabling a streamlined connection between line-of-business systems and Content Manager.

Extract, Transformation & Load: bulk record imports and updates

Bulk import or update records, including electronic, digitised, or hardcopy records, often from providers like Iron Mountain or Grace. This aims to manage legacy records from system retirements or integrations, and/or perform bulk updates for record destructions, movement tracking, or file closures. Includes features beyond Content Manager dataport, such as hierarchical record creation, enhanced record matching, and data transformation capabilities like manipulating text formats or creating multiple records from a single CSV row.

Check out how CASA faced challenges with legacy systems containing poorly managed, non-compliant records and images, compounded by inefficient manual metadata transformations. To resolve these issues, iCognition used its Ingress Connector as an ETL tool to automate data transformation, validation, and hierarchical imports, addressing data quality issues and simplifying bulk migration into OpenText Content Manager. This improved compliance, enhanced metadata quality, reduced errors, increased efficiency, and cost savings. Full case study here.

Network Drive imports and updates

Transition network drive data to Content Manager, preserving the original folder and document structure for seamless browsing. Full Business Classification Scheme (BCS) integration supported, allowing BCS terms (or record types) to be applied to specific folder levels. Apply granular control over certain file types or directories, or even choose to manage data in place without importing it into Content Manager.

Our team provides tailored solutions using the best technology.