Reading MS Outlook data in SAP DS

[Former Member]

Hello All -

I have a requirement to read MS Outlook data into SAP DS. Is their an adapter in SAP DS for integration with MS Outlook ?

Thanks!!

[akhileshkiran]

Hi Former Member

If your trying to use the Outlook data in Data Services. Outlook as a option to export the data as a .CSV file format. But which is not reliable for the Data Services because of the Body Content Field Data. Though there are no direct ODBC drivers or Exporting the data to excel. Only option i can see is Access Database.

But you can try using the remapping of the required column data.

Orelse you can try another method. You can export the data in to the Access Drive to .mdb format.

You can export the MS-Outlook Data with specified folders and content. Save this file as .mdb format.

create a ODBC Connection and Create a Datastore in the DataServices Designer import the required tables.

DataStore:

After importing the tables am not able to see the data from the source table. I tried creating the job and transferred the data to the staging area. Then i was able to see the data in the staging table successfully .

Output:

Database:

I hope this will help you out.

Regards,

Akhilesh Kiran.

[Former Member]

Excellent reply Akhilesh.

How can I automate this process? Is their anyway to configure a process that sends data from MS outlook to MS access periodically ?

[akhileshkiran]

Hi Former Member

There is a option while import the data from outlook to access. But we cannot directly use the linked table as source in the Data Services. May be we have an option to sync tables need to check it out.

Regards,

Akhilesh Kiran.

[akhileshkiran]

Hi Former Member

You can try creating a Custom Query in the Access Database for the Linked Table. So that we can use the query as a View in the Datastore. You need to have access permission for using the Query as a View for the user.

Regards,

Akhilesh Kiran.