CODEWITHSUNDEEP
javamysqletl
iamjustcoder
iamjustcoder

Reputation: 4852

Extract And Save mysql data

I have a data is about 30-40GB and it represents as XML and stored as BLOB in MySQL server. I want to create a new table, that should parse the XML and extract particular attributes to store as different columns(10-20 columns).

Is there any good ETL tool is available to do this?

NOTE: Currently i am simply using JDBC and Java to this transformation.

Upvotes: 1

Views: 64

Answers (1)

cdaiga
cdaiga

Reputation: 4939

Try Talend Open Studio for data integration. You will need to use the tFileInputXML component to read the file, you can check this tutorial out. The result from this component can be processed and loaded into your database using a tMySQLOutput or tOracleOutput or any other database input component.

Upvotes: 1

Related Questions