Toad World® Forums

Toad 3.5 SharePoint

Is SharePoint supported in Toad Data Point base, or is the professional version required?

Connecting to SharePoint is a feature in pro edition only. However, import/export data from a SharePoint site is available in base edition. You can configure the site in options | environment |SharePoint.

I’m trying to configure, but I’m getting an error when I try to put in the site address. The site address I’m using is:

http://rxconnect.davita.com/Functions/IT/Reporting/Lists/reportrequestdetail/Open%20Requests.aspx/

The site address works when I put it in a browser. Our site does ask for userID/password

Is there anything else I need to do in SharePoint to access this site, or should there be a different address that I should be using?

I’ve checked with our SharePoint admin, and we are on SharePoint 2013.

screenshots_20140423.docx (191 KB)

Please login using your browser, then use

http://rxconnect.davita.com/Functions/IT/Reporting/Lists/reportrequestdetail

or http://rxconnect.davita.com/Functions/IT/Reporting/ to see if it works.

That gave the same result (option/environment/SharePoint - ‘Test’) as the whole link name.

In the browser, ‘/Open%20Requests.aspx’ gets added automatically.

If I want to sent data to a SharePoint site what do I have to do to be able to do that. I have Toad Data Point 3.5 Professional and the SharePoint site is a version 2010.

I was able to get a SharePoint URL to Test but I can’t get it to connect. I have added the /_vti_bin/ListData.svc to the end of the URL as Toad requests but it still doesn’t work. The administrator gave me access to post to this SharePoint site so that should not be the issue.

bill.h.lee ,

Unfortunately, we only support windows default credential access to SharePoint right now. I’ve entered an enhancement request QAT-2647to support network credential access, namely, using username/password.

shanson2,

I would suggest using import to sharepoint features as well if you just want to add/insert some data to a sharepoint list provided you can access the site via windows default credential. In this case you don’t need /_vti_bin/ListData.svc suffix in the options page.

If you’d like to connect to sharepoint directly and using sql to manipulate data, please open connection manager, select sharepoint category and enter the server URL with /_vti_bin/ListData.svc suffix, and enter your username/password to connect. Let me know if it helps.

what level of sharepoint security do you need to create a direct connection as stated in your 4-25-2014 posting. I am trying to create a direct connection and have failed so far :frowning:

What version of SharePoint are you trying to connect to? We support 2010 and later. If that is not the issue what error do you get? Can you post a screenshot of how you are defining the connection and the error?