Oracle Communities

Oracle Analytics and AI

Child Item

Migration from OAS to OAC

If we leave our data warehouse on-premises but move from On Prem OAS24 to OAC, what additional functionality would be available?

Obviously we would get updates more frequently - but I’m thinking more about the ML/AI features.

We are in a competitive situation with other BI providers and moving to OAC seems a simple migration that may provide benefits.

Not clear whether things like Auto ML and the newer AI capabilities require ADW as a data source.

Find more posts tagged with

OAC MIGRATION

Accepted answers

Gianni Ceresa

The OCI services aren't directly dependent on OAC, they are just cloud-only services that can be called (via APIs) from tools like OAC and OAS.

Of course those tools (OCI AI services) requires the data to be available to them, using OCI Object Storage in general, and because of that they feel more "natural" when used with OAC because you are on a full cloud setup.

As for AutoML, the doc still says it is available for datasets from a "Oracle Autonomous Data Warehouse" connection. Therefore, to use it, you will need to move the data you need from on-premises to a cloud Autonomous DB, and there you have AutoML. Maybe you will get most benefits from using the cloud with AutoML to identify the model and parameters for your need, but to "deploy it to prod" on your own database on-premises once you identified it (data scientist exploration job vs production usage of ML).

If your on-premises data warehouse is an Oracle Database, you can already use for free the same ML models as Autonomous DB would have (depends on your database version: newer version added extra models and options).

As Federico said, there are also a number of things that do not exist in OAC, and if you are a historical OBIEE/Oracle Analytics user, you maybe are using some of those.

I would carefully go over the various documents and play with a OAC sandbox a bit first, to make sure that you really need OAC for the features you are interested in. Because just going to OAC keeping your data on-premises, you will maybe discover that some services are still not available because of other cloud dependencies, or that your main requirements was mostly integration to send data to the cloud to be able to use the OCI AI services even from your on-premises OAS.

peacey

Thanks everyone. Plenty of good input here- I need to go away and think

All comments

Ram-Oracle

@peacey Moving from on prem OAS environment to OAC offers advanced machine learning features though your data warehouse remains on your private subnet.

From the below documentation,it mentioned as following

In Oracle Analytics you can consume predictive models or machine learning models that reside in Oracle Database, Oracle Autonomous Data Warehouse, or Oracle Cloud Infrastructure (OCI).

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/use-oracle-analytics-predictive-models-and-oracle-machine-learning-models.html

please confirm if you are using on prem datawarehouse as oracle database?

Please also refer below document which suggests that NLG feature only available on OAC product

Natural Language Generator(NLG) Feature Not available on Oracle Analytics Server (Doc ID 2707241.1)

Some more useful blogs https://blogs.oracle.com/coretec/post/analytics-key-features

Other suggestions are welcome.

Federico Venturin - Oracle

Hi @peacey ,

Moving from OAS 2024 to OAC, you will get all the features that have been release since March 2024:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/

You should not focus exclusively on the new features and cloud benefits over on-premises solutions. I highly recommend to have a look at all the features that you are probably using but are not available in OAC (e.g. Act As), or work in a different way:

https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html#GUID-5B9072FD-C869-4EC4-A81A-FBF68F0C785D

Moreover, cloud services may have limitations compared to on-premises solutions. Again, I recommend to take some time to review existing OAC limitations:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/what-sizing-options-are-available-you.html#GUID-7D6DB4EE-8DD5-44C5-9B6E-9FA847463A5F__OCPU

Running a PoC with a limited (but important/critical) set of content and users would definitely be a good idea.

peacey

One of the things I was looking at was how we might integrate with OCI document, OCI Vision and maybe LLMs. Thinking that it may be easier with OAC.

Gianni Ceresa

The OCI services aren't directly dependent on OAC, they are just cloud-only services that can be called (via APIs) from tools like OAC and OAS.

As Federico said, there are also a number of things that do not exist in OAC, and if you are a historical OBIEE/Oracle Analytics user, you maybe are using some of those.

peacey

Thanks everyone. Plenty of good input here- I need to go away and think