Until the new year, the OpenAccess ODBC driver for Salesforce is available for the low price of $99 dollars per year.

Please visit http://www.openaccesssoftware.com/products/openrda/sfpricing.asp for more information and to sign up for the annual program.

Please visit http://www.OpenAccessSoftware.com/products/openrda/Salesforce_overview.asp to learn more about the OpenAccess ODBC Driver for Salesforce.

Thank You

OpenAccess Software, Inc.

Until the new year, the OpenAccess ODBC driver for Salesforce is available for the low price of $99 dollars per year.

Please visit http://www.openaccesssoftware.com/products/openrda/sfpricing.asp for more information and to sign up for the annual program.

Please visit http://www.OpenAccessSoftware.com/products/openrda/Salesforce_overview.asp to learn more about the OpenAccess ODBC Driver for Salesforce.

Thank You

OpenAccess Software, Inc.

Message Edited by openaccess on 11-18-2005 04:54 PM

Message Edited by openaccess on 11-18-2005 04:54 PM

How can we pass Proxy credentials when using Sforce Web services API? Can you provide sample code in C#?

Thanks
Dipak

Hi,

We are occasionally getting the above error message from SaveResult of update operation. The actual update operation is being applied to the object. The same error was observed from insert API result too.

What is the reason for such an error. We are using the sforce API from .NET.

Thanks

 

 

 

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

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

We at OpenAccess Software are debating the value of providing SQL compliant access to saelsforce.com and would appreciate any comments.  The objective is to provide a ODBC driver that allows the use of full SQL to perform read and write operations against any salesforce.com object. This would allow the use of MS Office, Crystal, and 100's of other applications to quickly access your data.

Thank You

We at OpenAccess Software are debating the value of providing SQL compliant access to saelsforce.com and would appreciate any comments.  The objective is to provide a ODBC driver that allows the use of full SQL to perform read and write operations against any salesforce.com object.

Thank You.

Dipak

Hi,

We are occasionally getting the above error message from SaveResult of update operation. The actual update operation is being applied to the object. The same error was observed from insert API result too.

What is the reason for such an error. We are using the sforce API from .NET.

Thanks

 

 

 

Last Jannuary, I talked to OpenAccess, a developer of toolkits for developing ODBC connectors, about using their product to build a connector to Salesforce.com. Although I got a 30-day trial, developing the actual connector was beyond my skills.

Last week OpenAccess contacted me about a beta version of an ODBC connector for Salesforce.com. You can download the beta version at:

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

The installlation requires that your computer have the  Microsoft.Net framework runtime installed (obtainable from http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en).

Once you install everything (about 10 minutes), you can use the  ODBC connector to link any ODBC-compliant app to your Salesforce database.

At present, there is no pricing or licensing cost on the web site. The beta license expires on September 27. Also, the ODBC connector only supports the SELECT statement, so no UPDATE or CREATE at the moment.

I testing it by creating an ODBC connection in Excel using the new salesforce ODBC connector as my source. I could then point/click to select from all the tables in my account, including custom objects.

Lots of possibilities here, but this is all the information I have. If you want more info, contact OpenAccess.

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

We at OpenAccess Software are debating the value of providing SQL compliant access to saelsforce.com and would appreciate any comments.  The objective is to provide a ODBC driver that allows the use of full SQL to perform read and write operations against any salesforce.com object. This would allow the use of MS Office, Crystal, and 100's of other applications to quickly access your data.

Thank You

We at OpenAccess Software are debating the value of providing SQL compliant access to saelsforce.com and would appreciate any comments.  The objective is to provide a ODBC driver that allows the use of full SQL to perform read and write operations against any salesforce.com object.

Thank You.

Dipak

Is it possible to connect to salesforce through sql serve and manage are data on a real time basis as we were to use toolkits from sforce? If so, how and what would we need?

We need to somehow get our order data from MivaMerchant-based website/cart over to SalesForce in the form of a new account. This needs to be done live-time. Miva currently emails us order data at time of order and I'd imagine that turning those emails into accounts would be the best way to go about this.

Please contact me directly if you can do this.

Thank you,

Andrew (awalker@pooltables-direct.com)

PoolTables-Direct.com

877-796-6800 | 772-446-0966

We are looking for a contract developer to integrate Macromedia Breeze with Salesforce.com.

On a weekly or daily basis we want to make a call to the Breeze servers and return presentation ID, presentation name, author, and number of views. This information will be written into a Salesforce.com custom object.

The code could be kicked of manually by a user, it does not need to be scheduled.

We would like the code to be written in Java. The ideal contractor knows Sforce, and the Breeze APIs, but we can provide documentation for the Breeze APIs.

Please contact bjasik at salesforce.com if you'd be interested in this.

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!

We currently have an internal application running off of a (somewhat) normalized SQL Server DB and we are evaluating a potential migration of the app/data over to SF. 

Question:  Is there a tool which will allow us to easily export all of our customers (4000+), leads (2000+) and vendors (500+) over to the SF platform directly from SQL? 

(ie. I'm assuming this would utilize a data junction). 

Thanks, Chris

Is there a way to connect to Salesforce via ODBC?