Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Aish123
Contributor
Contributor

How to use tSipcreator for extracting the data from database

Hi,

 

I have to create a job in which the input data is  from database and i want to ingest it in infoarchive.

I want to use  "tsipcreator" component for this.

Data involves images in blob format.

Is it possible to extract images through this component?

Can you please help out with how to achieve this job?

 

Labels (1)
11 Replies
Anonymous
Not applicable

Hi @Aish123 ,

 

Even I have unstructured data, My scenario is I have a reference column in the CSV file for the unstructured data and the sip package should contain the unstructured data along with the eas_pdi.xml and eas_sip.xml. 

I tried using the tFileArchive, but I was not able to get the SIP package as expected.

 

Could you please help me how you have added the unstructured data into SIP package along with the eas_pdi.xml and eas_sip.xml.

 

 

Aish123
Contributor
Contributor
Author

Hi @vvengala ,

 

My entire data was present in one database including the content files(images), So i created the db connection extracted all the schema in it and used all the database tables as my input.

 

Then mapped it using "tXMLmap" component and created an "eas_pdi.xml" file.

For "eas_sip.xml" file i created an excel file with all the basic details which are needed in it and used it as an input and then by again using tXMLmap created an "eas_sip.xml".

 

My content files were images so i downloaded them from database on my system at one specific location and also stored the "eas_pdi.xml" and "eas_sip.xml" in the same location.

 

Then used "tFileArchive" component giving "source path" which was mentioned above and the destination path of "data" folder inside the Infoarchive application. "tFileArchive" is a standalone component so no need of giving any connection. You can drag and drop on your designer and just specifiy the paths and it should work.This worked for me. 

 

Regarding your scenario, what does your .csv file consist of and where are the actual content files present? And how are these two related?