function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jhustijhusti 

SQL Server Reporting Services

I am trying to develop a Microsoft SQL Server Reporting Services report by plugging into the sForce.com web service.  Is this functionality currently available?  If so, how do I reference the web service from MS Reporting Services?

Thanks in advance!

qmanqman

I might have a solution for you. Contact me at bemerson @ forceamp.com.

Bill Emerson

openaccessopenaccess

One option is to use ODBC connectivity. This will allow Microsoft Report Services to see sforce as a SQL compliant database.

You are welcome to download a preview version of the OpenAccess ODBC Driver for Salesforce.com. It is available at:

http://www.OpenAccessSoftware.com/support/SalesF-Files-Index.asp

The preview version allows READ access (SELECT) from Salesforce. It will expose all the objects you have acess to, including any custom objects/fields you have added. Please try it out and give us your feedback.

Using the OpenAccess ODBC Driver for Salesforce allows any application or development tool that is able to access data from databases like SQL Server and Oracle to access your data at Salesforce.com.

OpenAccess Team
http://www.OpenAccessSoftware.com

gudduguddu
hello ,
You have written that you have added custom field to Lead/Account.
I also have to add custom field to account and lead . I am using Sforce 6.0 API and asp.net using c#. Can u guide me how can i add this ?
i am using partner WSDL.

Thanks
gudduguddu
hello ,
You have written that you have added custom field to Lead/Account.
I also have to add custom field to account and lead . I am using Sforce 6.0 API and asp.net using c#. Can u guide me how can i add this ?
i am using partner WSDL.

Thanks