Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?