Connecting Oracle Analytics Cloud to On-Premise Sources

When planning a migration to Oracle’s Cloud suite for Business Intelligence, it can feel daunting if you have spent years building and refining an on-premise BI ecosystem.

The key point is this: migrating to Oracle Analytics Cloud does not require a fully cloud-based architecture.

In many cases, OAC can connect to an existing warehouse and provide a hybrid cloud/on-premise solution.

Oracle cloud transition

Why a Hybrid Model Matters

Established BI programs can take advantage of OAC’s benefits, such as not having to own and maintain hardware, easier access to the latest versions and features, and mobile-ready access from almost anywhere, while still keeping core on-premise data platforms in place.

Because OAC is offered as a Platform as a Service, Oracle provides the cloud space and services required to operate the environment, but your organization is still responsible for standing it up, maintaining it, and administering it.

Important Security and Infrastructure Considerations

Before choosing a connectivity option, involve your internal network, security, and infrastructure teams as early as possible.

Remote Data Connector

If your on-premise data source is an Oracle database, the easiest method of connecting it to OAC is often the Remote Data Connector.

VPN as a Service

If your data sources are not Oracle databases, then VPN as a Service is often the most common approach.

Fast Connect

Oracle also supports Fast Connect, which establishes direct connections between your data center and the cloud environment.

Conclusion

If you are considering upgrading and migrating to Oracle Analytics Cloud but are unsure how that affects your existing data marts, Oracle provides options that support practical hybrid cloud solutions.

MindStream Analytics

Want to know more about connecting OAC to on premise sources? Please complete the form below and we’ll get back to you shortly.