Data pipelines out of Fusion and into decisions
Fusion data where analysts, models and other systems can use it.
BI Cloud Connector, Fusion Data Intelligence, OCI Data Integration, GoldenGate and Autonomous Data Warehouse: reliable pipelines that land Fusion and enterprise data for analytics, AI and downstream systems.
Sources
- Fusion ERP / SCM / HCMBICC · REST · BIP
- EBS / on-prem DBGoldenGate CDC
- CRM, operational systems
Land & transform
Object Storage → OCI Data Integration → ADW
Incremental · reconciled · versioned
Serve
- Fusion Data Intelligence
- Oracle Analytics
- AI Vector Search / models
- Snowflake / Power BI
Overview
Data Integration, done properly.
OTBI answers questions inside Fusion. Everything else, history beyond retention, blending with CRM and operational data, feeding a model, publishing to a corporate warehouse, needs data out of Fusion reliably and incrementally. AMTEX designs and runs those pipelines with the same engineering discipline as our integrations: incremental, reconciled, monitored and versioned.
Technologies
- BI Cloud Connector (BICC)
- Fusion Data Intelligence
- OCI Data Integration
- Oracle GoldenGate
- Autonomous Database
- Oracle Analytics Cloud
- SQL & PL/SQL
What we deliver
Capabilities
Everything AMTEX builds, configures and runs across Data Integration.
BI Cloud Connector (BICC)
Offerings, view objects, incremental extract schedules and Object Storage landing, with reconciliation to source counts.
Fusion Data Intelligence
Implementation and extension of FDI (formerly Fusion Analytics Warehouse): activation, security, custom data augmentations and semantic model extensions.
OCI Data Integration
Data flows and pipelines transforming landed extracts into warehouse models, orchestrated and monitored.
GoldenGate
Change data capture and real-time replication from on-prem Oracle, EBS and other databases into ADW or OCI.
Autonomous Data Warehouse modelling
Dimensional models, data marts and the security layer that mirrors Fusion's data access rules.
Data quality & reconciliation
Row counts, control totals and business reconciliations run with every load and surfaced when they break.
Publishing to other platforms
Feeds to Snowflake, Databricks, Power BI or a corporate lake when Oracle is one source among many.
Data Catalog & lineage
OCI Data Catalog and documented lineage so analysts trust where a number came from.
The hard parts
Where these projects become difficult
The places programmes slip, and what we do about each one.
- 01
Full extracts every night
The problem
Extracts that pull everything, run for hours and fail when the window shrinks.
How AMTEX approaches it
Incremental BICC with watermarks, partitioned loads, and a backfill path that does not need a weekend.
- 02
Warehouse security drift
The problem
Users see data in the warehouse they cannot see in Fusion.
How AMTEX approaches it
Security policies derived from Fusion roles and business units, tested with real user profiles.
- 03
Numbers that do not tie
The problem
Finance and the warehouse disagree and nobody knows which is wrong.
How AMTEX approaches it
Reconciliation to Fusion reports as a pipeline step, published with the data.
How we work
From first conversation to steady state
01
Requirements
The questions to answer, the systems involved, the refresh needed.
02
Architecture
BICC vs FDI vs GoldenGate per source, warehouse model, security.
03
Build
Pipelines, models, reconciliation, dashboards; all in source control.
04
Operate
Monitoring, cost management and change control as Fusion updates.
Related solutions
Oracle Cloud Infrastructure
OCI architecture for the workloads that live around Fusion: Autonomous Database, Functions, API Gateway, Object Storage, networking, identity and observability, designed for security and high availability.
Oracle E-Business Suite Modernisation
Coexistence, integration, OCI hosting and phased migration for organisations running Oracle E-Business Suite, whether the destination is Fusion or a longer life for EBS.
Oracle Reporting & Analytics
OTBI, BI Publisher, HCM Extracts, Oracle Analytics Cloud and Autonomous Data Warehouse, designed as part of the implementation rather than bolted on after.
Oracle AI & Generative AI
OCI Generative AI, Generative AI Agents, AI Vector Search in Autonomous Database, Fusion AI Agents, OCI Language, Speech and Vision, and Oracle Digital Assistant, applied to real finance, supply chain and HR work with human review built in.
Extracts breaking, or a warehouse nobody trusts?
We will map the sources and tell you which pipeline pattern fits each one.