• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 49
  • Last Modified:

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?
0
marrowyung
Asked:
marrowyung
  • 8
  • 7
1 Solution
 
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now