We are exploring options to change our ERP from a legacy system to SAP Cloud and hence we need to understand options to source the required SAP data for TM1. 

One option is to feed SAP data to our data warehouse and we then feed TM1 from there. This might be the easiest option. 

Another is to source data directly from SAP. Given Server 12 local is off the table we need to explore options for Server 11 only.

1. From what we have been told, there would be no way to use ODBC against SAP Cloud. 
2. Text file exchange is of course an option with SAP exporting to a schedule with file transfer for TM1 to then use in loads but I'd prefer to avoid the text file path and also be in a position to extract data "on demand"
3. There appears to be a TM1 to SAP connector that was released early last year but I haven't been able to find any useful information about it. It appears to be an ODATA based interface run from command line but other than that I have found nothing.I would really like to understand how it works and in particular how well it can be integrated to TI's (Perhaps using execute command) and what sort of end-to-end experience can be achieved.  If anyone has knowledge of/ experience with this  connector I would be interested in any information you can provide.  If you wish to PM me that would be fine

Thanks

Some time ago, when IBM released the IBM Planning Analytics Connector for SAP, they run a webinar.
The recording of said webinar is no longer online, but the slide deck of the presentation is still offered for download by the second link.

Links:

1)
https://community.ibm.com/community/user/discussion/webinar-making-the-most-of-your-sap-data-with-the-ibm-planning-analytics-connector-for-sap#bma6a21e1b-8cc9-4da8-b45a-35b22750e8df
Webinar: Making the most of your SAP data with the IBM Planning Analytics Connector for SAP

2)
https://community.ibm.com/community/user/viewdocument/webinar-making-the-most-of-your-sa-1?CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b
Webinar: Making the most of your SAP data with the IBM Planning Analytics Connector for SAP

3)
https://community.ibm.com/community/user/blogs/sami-el-cheikh1/2024/01/05/make-the-most-of-your-sap-data-with-the-ibm-planni
Make the most of your SAP data with the IBM Planning Analytics Connector for SAP!