how can Oracle work with AWS/Azure easily

hi,

can oracle move data easily between AWS/Azure, can local oracle installation can work with Cloud easily. e.g. archive data move  back and forward to cloud easily
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Remote databases are remote databases.  It doesn't really matter if it is a data center across the country or the Cloud.  Remember, the Cloud is just someone else's computers.
Shalom CarmelCTOCommented:
To get a good answer, you have to ask a good question.
So although the broad answer to your question is yes, the devil is in the details.
So if you have a specific technical or business scenario in mind, please give us the details of what you want to do.
marrowyungSenior Technical architecture (Data)Author Commented:
slightwv,

" Remember, the Cloud is just someone else's computers."

agree !


Shalomc,

what I want to know is, as MS SQL can integrate the Azure SQL Database within the same management console so that it can archive very old data to the Cloud and live data still on local database, I want to know if the same thing is going to happen in oracle.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

slightwv (䄆 Netminder) Commented:
>>I want to know if the same thing is going to happen in oracle.

I tried to cover that in my post.  Let's try it this way:  Oracle databases are Oracle databases no matter where they run.  If you can do it in Oracle between data centers on the East Coast and West Coast, you can do in between a local database and one in the cloud.
marrowyungSenior Technical architecture (Data)Author Commented:
"Oracle databases are Oracle databases no matter where they run.  "
excellent

" If you can do it in Oracle between data centers on the East Coast and West Coast, you can do in between a local database and one in the cloud."

I mean can both instance then manage in a streamline way ! like the tools will manage the live and archive data automatically ?
slightwv (䄆 Netminder) Commented:
Again, Cloud versus no-Cloud:  It doesn't matter.

As far as a tool, Oracle Enterprise Manage Cloud Control:
https://docs.oracle.com/cd/E63000_01/EMCON/overview.htm
marrowyungSenior Technical architecture (Data)Author Commented:
tks.

can I get it done using oracle developer tools like SQL developer  ?
slightwv (䄆 Netminder) Commented:
I don't know what all you plan on managing so I cannot answer your question.

You can do a lot with SQL Developer.  Just not sure you can do everything you want.

Note that SQL Developer will require you to open up the firewall to allow direct connections to the database from your client machine.  That may or may not be an issue.

Doing things through OEM uses the agent running on the server and OEM talks to the agent.
marrowyungSenior Technical architecture (Data)Author Commented:
"I don't know what all you plan on managing so I cannot answer your question."

I mean manage the local oracle and oracle cloud by a single management console and I am expecting Oracle internally will have a method to get archived data (e.g 8 years ago)  in and out from cloud AUTOMATICALLY, transparent to the application.
Shalom CarmelCTOCommented:
Hello,

I suggest that you post a fresh question tagged as Oracle with the content of
"How to manage the local oracle and oracle cloud by a single management console, and have a method to get archived data (e.g 8 years ago)  in and out from cloud AUTOMATICALLY, transparent to the application."

This is a specific question that will get the eyes of Oracle experts.
I personally do not know if this is possible.
slightwv (䄆 Netminder) Commented:
>>mean manage the local oracle and oracle cloud by a single management console and

Oracle Enterprise Manager Cloud Control.  That is Oracle's enterprise management tool.  It has nothing to do wth the databases are local or in the cloud.

>>I am expecting Oracle internally will have a method to get archived data (e.g 8 years ago)  in and out from cloud AUTOMATICALLY, transparent to the application.

I don't understand this statement.  If you define 'archive data' to mean take old data that is no longer needed for day to day operations and pull it form the table and store it externally, then Oracle doesn't have an automatic 'data archive' process.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
"I don't understand this statement.  If you define 'archive data' to mean take old data that is no longer needed for day to day operations and pull it form the table and store it externally, then Oracle doesn't have an automatic 'data archive' process. "

exactly this .

"Oracle Enterprise Manager Cloud Control."

so this can also manage local Oracle DB?


tks.
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
slightwv (䄆 Netminder) Commented:
>>"Oracle Enterprise Manager Cloud Control."

It is just a name.  Remember ALL databases are remote databases.  They are typically on a different server than the applications that access it.  Where that server resides doesn't matter.

>>so this can also manage local Oracle DB?

Yes.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.