Skip to Content
avatar image
Former Member

Reading MS Outlook data in SAP DS

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!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 12, 2016 at 04:14 PM

    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 😔

    Output:

    Database:

    I hope this will help you out.

    Regards,

    Akhilesh Kiran.


    Add comment
    10|10000 characters needed characters exceeded

    • 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.