extract data from Emails, PDF files ?

chandra_babu_999 · Post by **chandra_babu_999** » Tue Sep 16, 2008 6:16 am

How can we be able to extract data from Emails, PDF files?

chulett · Post by **chulett** » Tue Sep 16, 2008 7:48 am

Short answer? No. You might want to expand on what 'extract data' means, however. Any specifics you'd care to share?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:16 pm

When's the interview?

IBM has lots of information it wants to share with you about accessing unstructured data.

chulett · Post by **chulett** » Tue Sep 16, 2008 3:26 pm

There's that. There was also a ClickPack available that would allow you to access emails and weblogs from what I recall, but I say "was" because AFAIK support for it has been dropped and it's not a part of the 8.x release. It was kind of interesting as it brought Perl support into DataStage.

I don't think you could even do much with a pdf. Unless, perhaps, you had your hands on a third-party tool / bridge / something that could read them. [shrug]

John Smith · Post by **John Smith** » Tue Sep 16, 2008 5:07 pm

Hi,
PDF files are usually hard to extract but it is possible. There are software (not Datastage though) that you can use to read PDF and then convert into Excel or CSV files. One that comes to mind is called Able2Extract. Just Google it.
Once it's in CSV format then you can use Datastage to process it.

As for Emails, it depends on what email system.The underlying email database may be queryable.

Cheers,
JS

chandra_babu_999 · Post by **chandra_babu_999** » Tue Sep 16, 2008 9:38 pm

ray.wurlod wrote:When's the interview?

IBM has lots of information it wants to share with you about accessing unstructured data. ...

Hi ray,

Thanks for the reply.

Actually we are evaluating different etl tools to suggest to my client.My client has a requirement to extract the data from MS-Excel,XML,E-Mails and PDF's.
As per my knowledge Datastage is satisfying all the requiements but need to clarify wether it can able to extract Email and PDF data.

I was ot sure what kind of data does Email system has at this point.

chandra_babu_999 · Post by **chandra_babu_999** » Tue Sep 16, 2008 9:40 pm

ray.wurlod wrote:When's the interview?

IBM has lots of information it wants to share with you about accessing unstructured data. ...

Hi ray,

Thanks for the reply.

Actually we are evaluating different etl tools to suggest to my client.My client has a requirement to extract the data from MS-Excel,XML,E-Mails and PDF's.
As per my knowledge Datastage is satisfying all the requiements but need to clarify wether it can able to extract Email and PDF data.

I was ot sure what kind of data does Email system has at this point.

chandra_babu_999 · Post by **chandra_babu_999** » Tue Sep 16, 2008 9:42 pm

John Smith,

Thanks for the reply..