Export to Sharepoint 365 Lists Using Toad Data Point

Toad Data Point & Toad Intelligence Central
1

I'm trying to export data to a Sharepoint 365 List.

According to the help documentation:

"You can import data and create tables (lists) in a SharePoint site using the Export wizard in Toad."

When using the Export Wizard, it says that the connection needs to be defined in: Tolls > Options > Environment > Sharepoint

I can't seem to connect to my Sharepoint 365 environment using this method. Is Sharepoint 365 supported? If so, can anyone offer any assistance around how to configure this screen for Sharepoint 365?

Thanks,
Jon

2

I have the same issue, trying to connect to SharePoint online and help docs indicate its possible but getting an ADFS token error.

3

Sharepoint 365 is not supported in Toad Data Point 5.4. I will add this to the idea pond to be considered for an upcoming release.

4

Hello, 3 years later has Support for Sharepoint Online been Implemented? I can read from a 365 List but I cannot export to one.

5

Following up with dev, stay tuned...

6

Thanks Julie, standing by.

7

Connecting to SharePoint Online (SharePoint 365) using AD Universal authentication with MFA is supported from the Toad Data Point 6.0 version. Exporting data directly to the SharePoint Online list using MFA authentication is not. As a workaround, you can now connect to the SharePoint list, work with it, export it to Excel or CSV files locally, and then upload it manually to SharePoint Online.

For the next Toad Data Point release, planned for the first half of next year, we plan to support connection to the SharePoint Online files (Excel, CSV) and exporting data directly to SharePoint Online files (Excel, CSV).