Use MySQL connection from repository within a sqoop component

One Star

Use MySQL connection from repository within a sqoop component

Hey,
i'm using Talend Open Studio for Big Data and trying to load some table data from a MySQL database to HDFS with Sqoop. I'm using a tSqoopImport component with my predefined HDFS metadata. Now i want to use a DB Connection schema from my repository where the data shall be fetched. But when i want to choose a connection from the repository there is no connection although they are in the metadata section in the repository (not in the window that appears to choose a conn).
Is it not possible to use a predefined connection and do i have to type it in manually?
Thanks!
Employee

Re: Use MySQL connection from repository within a sqoop component

I think this is a bug.  I encountered it as well.  Yes, I think for right now you need to use a builtIn hadoop profile within the Sqoop component. Just to save yourself some typing, reference your profile in the metadata repo and then change it to builtIn.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now