Qlik Community

Qlik Catalog

Discussion Board for collaboration on Qlik Catalog

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
brunnovb_in
Partner
Partner

Qlik Data Calatalyst and Sqoop - Database Import and Export

Hello everyone!
I am trying to make use of sqoop to import data to QDC (DB -> QDC) and also to export QDC data (QDC -> DB), but I am not succeeding. I've used several sqoop command attempts, like the example below. Could you support? An example of trying sqoop command is below.

sqoop import --connect "jdbc: sqlserver: //apps.in1.com.br:1433; databaseName = DB_DEMO" --username qlik_demo --password 'qlik123' --warehouse-dir / demoqdc

Could you give me an example of sqoop import and export command?

Regards,

Brunno V.B.

Labels (1)
2 Replies
Clever_Anjos
Employee
Employee

@brunnovb_in why are you using scoop to onboard data and not using the regular workflow?

About exporting data to RDBMS, you could use the OPENCONNECTOR target and please check the manual

http://<yourserver>:8080/podium-webhelp/v1/index.htm#t=SOURCE%2FOPENCONNECTOR_Usage_and_Tips.htm&rhs...

lucassad
Employee
Employee

Hi Brunno,

Open Connector will run a sh script, so you will need to create a script to do a data import and additional properties to send the parameters to your script.

To create new properties and use in your sh script you will need to use QDC API to create them (PUT /propDef/v1/save).

You will find in QDC help 2 examples, DistCp script and Secure Copy (SCP/SSH) script, you can use the sample scripts to start your own.

---------

In case you are planning to insert data into an MS SQL DB you can also use the bcp tool in your sh script. I am adding some MS links here as a reference for you.

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-bcp?view=sql-server-2017

https://docs.microsoft.com/pt-br/sql/linux/sql-server-linux-setup-tools?view=sql-server-ver15

 

Thanks,