topic Re: How to use tSipcreator for extracting the data from database in Talend Studio

How to use tSipcreator for extracting the data from database

Aish123 — Mon, 06 May 2019 14:55:08 GMT

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?

Re: How to use tSipcreator for extracting the data from database

Anonymous — Tue, 07 May 2019 10:03:40 GMT

Hello,

It is a custom component written by talend community user and shared on talend exchange portal.

Please refer to this page:https://exchange.talend.com/?_ga=2.128538060.1993089361.1557110663-460644329.1557110663#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1432&pi=marketplace%252F1%252Fproducts%252F1432%252Fitems%252F2446

Best regards

Sabrina

Re: How to use tSipcreator for extracting the data from database

Aish123 — Tue, 07 May 2019 11:19:27 GMT

Hi,

Yes.I have downloaded that component from Talend Exchange.

But i have images in blob format in database which i need to extract it through tsipcreator.

Is it possible through this component?

Re: How to use tSipcreator for extracting the data from database

Aish123 — Wed, 08 May 2019 10:42:09 GMT

Hi,

Can you please help me on the above mentioned requirement.

Re: How to use tSipcreator for extracting the data from database

Anonymous — Wed, 08 May 2019 11:00:52 GMT

Hello,

The third party custom components on Talend Exchange are provided by Talend community users, since we don't have the source code of these components. It is the ownership of the person who built it. Feel free to contact the author directly.

Best regards

Sabrina

Re: How to use tSipcreator for extracting the data from database

Aish123 — Wed, 08 May 2019 11:16:53 GMT

Hi,

Thankyou for your response.

Can you please tell me how should i contact the author of this component?

Re: How to use tSipcreator for extracting the data from database

Aish123 — Tue, 14 May 2019 11:59:05 GMT

Hi,

Can you please tell me how can i contact the author of this component?

Re: How to use tSipcreator for extracting the data from database

Anonymous — Tue, 18 Feb 2020 11:12:38 GMT

Hi @Aish123 , Did tSipCreator worked for you ?, I tried creating SIP Package but it is throwing error for me. Please let me know if you are able to create SIP Package. Thank you

Re: How to use tSipcreator for extracting the data from database

Anonymous — Tue, 18 Feb 2020 11:19:40 GMT

@khandkI'm trying to create the sip package from a table data, but it is throwing error. Could you please tell me how did you create the how did you implemented this ? I'm not able to configure things properly in the tXMLMap. Could you please help me.

Re: How to use tSipcreator for extracting the data from database

Aish123 — Wed, 19 Feb 2020 06:00:44 GMT

Hi @vvengala ,

I tried with "tSipCreator" component, but it is not able to create the files in the way i needed them.

Also storing the content files inside the SIP package was my use case which i was not able to achieve it using this component.

Instead i created all the data files along with the content files in one folder and then used "tFileArchive" component to create an SIP package at the desired location.

Re: How to use tSipcreator for extracting the data from database

Anonymous — Wed, 19 Feb 2020 13:28:20 GMT

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.

Re: How to use tSipcreator for extracting the data from database

Aish123 — Thu, 20 Feb 2020 05:26:07 GMT

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?