Skip to Content
0

Using Outlook PST file as source in SAP Data Services

Oct 23, 2017 at 01:57 PM

74

avatar image

Hi,

Has anyone successfully used an Outlook PST file as source in SAP Data Services?

The PAM says it is supported from 4.2 SP07 but I couldn't see any guides on how it is done.

Thanks,

Mike

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Akhilesh Kiran Oct 24, 2017 at 02:30 PM
0

Hi Michael Coe,

please find the below link. I hope it will be helpful for you.

https://archive.sap.com/discussions/thread/3890341

Regards,

Akhilesh Kiran.

Share
10 |10000 characters needed characters left characters exceeded
Michael Coe Oct 24, 2017 at 03:53 PM
0

Hi Akhilesh,

Thanks for your reply. I can see that would work for a manual workaround. However, SAP are now stating there is native functionality in Data Services to directly read from a PST file (see attached).

This is what I was hoping to use but there are no examples or guidance I can find.

Thanks,

Mike

cusersuk18349documentsdata-services-pam-pst-file.jpg


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Michael Coe

Hope you are doing good. I have extracted data from an outlook email message but not sure about the whole PST folder. Logically the PST folder contains emails in the form of binary files. You can create a unstructured binary File format and then use it to extract data.

In the data flow, you can use a Text Data Processing transform such as Entity Extraction to process unstructured binary data

Below is an excerpt from Data Services Designer Guide under section 6.10 Unstructured Binary File Formats

Dirk Venken , Kindly need your valuable inputs/suggestions

Regards

tdp.jpg (95.0 kB)
0
Dirk Venken
Oct 25, 2017 at 07:52 AM
0

An Unstructured Binary File Format contains a blob column. In DS you can only do 2 things with a blob:

  1. Pass it to the ouput (a file or database table)
  2. Feed it into the Enity_Exraction transform for text processing
Share
10 |10000 characters needed characters left characters exceeded
Michael Coe Oct 25, 2017 at 10:40 AM
0

Hi Dirk,

Thanks for your response.

I was thinking that an unstructured binary file with entity_extraction transform was an option but not sure how you would pass the credentials to be able to unencrypt the contents.

All I can see is that you would be able store an encrypted blob field which is of no value.

Not sure what SAP intended when they added PST files to the officially supported file formats. I have logged a ticket with SAP but didn't get a response, I'm guessing no-one in support knows either.


Thanks,

Mike

Share
10 |10000 characters needed characters left characters exceeded
Graziano Oliveira de Morais Jun 19 at 01:40 PM
0

Michael Coe are you successfully used an Outlook PST file as source in SAP Data Services?

Share
10 |10000 characters needed characters left characters exceeded