Oracle ETL

hi,

Is oracle's ETL product is golden gate?

is it scale out/load balance enabled ?

what is the cost model for it?
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:
Goldengate is Oracle's replication product.  Not sure how it would aid you in ETL but I'm guessing you were reading something?  Can you provide the link?

MSRP prices are here:
http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

Not sure what you mean by scale/load balance.
0
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

I am checking and comparing DB feature, as I rarely focus on Oralce ETL, usually touch on MS SQL ETL, so I want to know if oracle ETL component can do scale out.

scale/load balance= if I have one more Oracle server installed and it has ETL component, or an ETL server, all ETL servers can join as in ETL farms and they work together to SHARE the workload of each other.

something like MariaDB's Cluster.
0
slightwv (䄆 Netminder) Commented:
Oracle has clustering.  I see ETL as a process not part of a database engine.  I know a little about SQL Server so if you can provide me information on what you mean by "MS SQL ETL", I can try to provide the Oracle equivalent.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

marrowyungSenior Technical architecture (Data)Author Commented:
" if you can provide me information on what you mean by "MS SQL ETL", I can try to provide the Oracle equivalent."

MS SQL SSIS, since SQL 2016, SSIS can scale out. it has been a big ETL bottleneck for a long time and everyone challenge on it. if it is busy! you can only scale up!


"I see ETL as a process not part of a database engine. "
in MS SQL , it is a separate service, included in the cost we paid !  no extra cost but very very powerful !
0
slightwv (䄆 Netminder) Commented:
Never used this but it appears Oracle has Data Integrator if you need such a tool for complex migrations from multiple data sources:
https://www.mssqltips.com/sqlservertip/4003/comparison-of-oracle-and-sql-server-management-tools/

That link gets you here:
http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html


If you don't need all the power that product offers, SQL Developer is free and has some data migration capability and many other features:
http://www.oracle.com/technetwork/database/migration/index-084442.html
0

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:
it is not migration, it is about I transform data so another format so that other process can start doing sth on it.

just like data wareshousing, usually we will do sth like tranditional DB query-> ETL -> analysis -> data warehouse.

I am therefore, focusing on how Oracle do ETL.

"Never used this but it appears Oracle has Data Integrator if you need such a tool for complex "

but tks.
0
slightwv (䄆 Netminder) Commented:
>>it is not migration, it is about I transform data

Moving data from pointA to pointB is sort of a migration, right?
0
marrowyungSenior Technical architecture (Data)Author Commented:
how about I say transfer ? moving in your statement can also mean from A to B and it is not existing in A anymore, right
?

the main objective of ETL is transform data to diff type, e.g., can you suggest the solution in oracle for it?

it is Extract , transform and load.
0
slightwv (䄆 Netminder) Commented:
I'm aware of what ETL means.

I use scripts, custom programs and tools like SQL*Loader when I've done it.  I've never used a GUI.
0
marrowyungSenior Technical architecture (Data)Author Commented:
so there are no ETL tier for Oracle ? I am not sure if it is true !

it seems Oracle data warehouse is the one ? and Oracle Data Integrator ?

It seems ODI is the latest approach that Oracle data warehouse for ETL for Oracle, right?
0
slightwv (䄆 Netminder) Commented:
I mentioned Data Integrator 4 days ago.  All I'm saying is that I've never used a tool per say to do ETL.  I've used scripts and custom written programs.
0
marrowyungSenior Technical architecture (Data)Author Commented:
" All I'm saying is that I've never used a tool per say to do ETL. "

they now called it ELT, oracle said better than ETL. tks for it.

BTW, do you know if ODI can scale out ? or load balancing  ?
 seems only cluster or HA  ?

https://docs.oracle.com/cd/E29542_01/core.1111/e10106/odi.htm#ASHIA4967
http://www.kpipartners.com/blog/bid/148200/ODI-Clustering-for-Load-Balancing-High-Availability-and-Failover

one line said:

Requests to the Oracle Data Integrator agent in a cluster must be routed via a load balancer or via an HTTP proxy server

Open in new window


it seems ODI relies on other component to do load balancing?
0
slightwv (䄆 Netminder) Commented:
Sorry but I don't know anything about ODI.
0
marrowyungSenior Technical architecture (Data)Author Commented:
it seems relies on load balancer and/OR oracle HTTP server to load balance, I doubt about it.
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
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.