Hello,

I’ve been trying to get DBAmp (2.3) working under SQL Server Express 2005 with no luck. So I will give a pre-emptive apology if this question has been answered before, sorry.

I can connect using the Excel connector with out a problem, but when I try with the DBAmp Configuration tool, no luck (Test Connection). When trying to connect I receive the following error:

Connection to SalesForce using DBAmp failed. Source: (null) Description: Error 5000: Unknown Exception in SyncRun::Api Request.

And when attempting to connect and issue a query like: SELECT * FROM SALESFORCE…Contact I receive this error under SQL Server 2005 Express:

Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

If anyone can offer a little insight I would really appreciate it.

Thanks,

- Tim

Currently running:
Sforce Office ToolKit : 3.00.0021
DBAmp 2.3
SQL Server Express 2005 w/ MS SQL Server Management Studio Express

What is the rule for UserEmail uniqueness ? Is it unique with for the sf universe, within an org, within an org but shared with its sandbox ?

I've noticed that I cannot create a new developer instance with the same email but my email can be added to another org as an id.

Thanks,

Bill

I'm thinking about upgrading Karl's old ADO.NET provider to work as a ADO.NET 2.0 provider with batch update capability and VS Desgin support.

Is there any interest in the .NET community for a new version of the provider ?

Thanks,

Bill

I'm using the sforce explorer pointed to the 7.0 endpoint and can't seem to find/query the ClosedWhenCreated field in the Case object definition. The field is documented in the 7.0 api docs as being a case field.

Thanks,

Bill

What is the 'Real-time database mirroring' mentioned as a feature of the Enterprise Edition ? This is in the edition comparison page under the AppExchangeAPI section.

Just haven't heard of it.

Thanks,

Bill

Does anyone know the status of the 2.0 version of the .NET Provider ? There was a presentation on it at Dreamforce, but the sourceforge site still has the 1.0 version.

Thanks,

Bill Emerson

See the Open Source forum for this and all future notices on DBAmp.

Bill Emerson

I just posted a new version of DBAMP, Version 2.3. This version fixes some bugs with the way decimal points were handled. There was also a bug with the Test Instance redirection that was fixed as well.

But the big news is the performance! A major improvement here, due to the detection of a nasty COM marshaling bug. See my blog for the technical details.

I'd recommend all DBAmp users at least download and begin testing this version on their test/developement machines. Wait a week and then if it all looks good, deploy to production.

DBAmp is open source and available at the forceAmp.com website.

And finally, I'd like to get some feedback. If DBAmp has worked for you or if you have a feature request, please drop me a line at bemerson @ forceamp.com .

Thanks,

Bill

In an earlier post, Linebacker asked:

DBAmp is great. I never asked for, but can i write my local changed datasets back to Sforce? How?

and my repsonse was:

I think what you're looking for is a way to import from SQL Server into Salesforce (kind of the opposite of SF_Replicate). You can do it a couple of ways: 1. Use SQL Data Transform Services to export your SQL table into a csv, then use dataloader to upload this csv. 2. Write your own custom stored proc that compares the ID and SystemModstamp between the local table and the SALESFORCE...Object to find differences. Then use an update SQL statement to update the values you want up on the SALESFORCE side. I am considering writing a SF_Import stored proc that does this, but I have kinda of a full plate right now getting DBAmp ready for the Winter '06 release. Any open source'ers that want to take a stab at it (with a little guidance from me) ?

Now, Benfishin and I have taken up the challenge. As a new open source project, we are going to write an import program that imports records from SQL Server into Salesforce.

But first, I would like to get some input from the community with regards to the features needed. For example:

1. Should it be similiar to the options provided by the Sforce Data Loader ?

2. Should it use the new UPSERT command in the api ?

3. Should it be batch mode or interactive or both ?

Let's make sforce open source work for all of us. If you have some ideas, suggestions, or just want to help develop open source solutions, respond to this thread with contributions you can make. I'll take care of the details of setting up the project in SourceForge and allocating the developer member id's.

Thanks, Bill Emerson

Message Edited by qman on 11-19-2005 07:16 AM

A new version of DBAmp has been posted that allows you to point DBAmp to your Salesforce test instances. The new version also contains several bug fixes.

Visit www.forceamp.com for directions on downloading the open source version.

Enjoy,

Bill Emerson

A new version (V2.1) of DBAmp as been posted at the DBAmp open source project. Details are available at www.forceamp.com . The new version provides UPDATE /DELETE support as well as some performance enhancements. Questions regarding DBAmp can be posted in this forum (Open Source).

Thanks,
Bill Emerson
forceAmp.com

Message Edited by qman on 10-28-2005 05:14 PM

A new version (V2.1) of DBAmp as been posted at the DBAmp open source project. Details are available at www.forceamp.com . The new version provides UPDATE /DELETE support as well as some performance enhancements. Questions regarding DBAmp can be posted in the Open Source forum. Thanks, Bill Emerson forceAmp.com

Message Edited by qman on 10-28-2005 05:12 PM

DBAmp is now open source and free ! If you are looking for a way to access Salesforce.com data via SQL SELECT statements or need to quickly replicate your Salesforce.com data into local SQL Server tables, check out the DBAmp open source project at www.forceamp.com. If you don't have SQL Server, you can download a free version from Microsoft called the SQL Server 2005 Express Edition and use it to host DBAmp. You can watch a Dreamforce presentation on DBAmp at http://www.crmsuccess.com/browse/content_detail.jsp?id=006300000034wbZAAQ&flid=02n300000000ID7AAM&slid=&tlid=02o300000000haWAAQ Thanks to all who participated in the beta program. Bill Emerson

Message Edited by qman on 10-28-2005 05:16 PM

Message Edited by qman on 10-28-2005 05:16 PM

DBAmp is now open source and free !
If you are looking for a way to access Salesforce.com data via SQL SELECT statements or need to quickly replicate your Salesforce.com data into local SQL Server tables, check out the DBAmp open source project at http://sourceforge.net/projects/dbamp .

If you don't have SQL Server, you can download a free version from Microsoft called the SQL Server 2005 Express Edition and use it to host DBAmp.

You can watch a Dreamforce presentation on DBAmp at http://www.crmsuccess.com/browse/content_detail.jsp?id=006300000034wbZAAQ&flid=02n300000000ID7AAM&slid=&tlid=02o300000000haWAAQ

Thanks to all who participated in the beta program.
Bill Emerson

Message Edited by qman on 10-17-2005 01:10 PM

Has anyone tried to use the Excel Connector / Office Toolkit thru a proxy ?

Any configuration suggestions would be helpful.

Thanks,

Bill

I've posted a new version of my code to connect SForce with SQL Server. The new code allows you use SQL Update, Delete and Insert statements as well as complex Select joins.

To try the beta, visit www.forceamp.com and register for the download.

Thanks,

Bill Emerson

Hi,

When I call the Delete method on an account that cannot be deleted because of existing cases, etc. , I do not get back an error message from the COM toolkit. Looking at the SOAPscope I see the following:

result {    errors    {       [xsi:nil = true]       fields = empty,       message = Delete Error: Your attempt to delete Acme Software could not be completed because it is associated with following Cases.,       statusCode = DELETE_FAILED    }    [xsi:nil = true]    id = empty,    success = false }

So I know that the api reports the error.  Here is my code:

try

{

// Retrieve id to row to delete

IField2Ptr idField = pCurSObject->Item("Id");

idField->PutValue(m_idStatusArray[iRow].id);

// salesforce.com delete

hr = pCurSObject->Delete();

}

catch (_com_error e)

{

// error occurred durning update

return (SFReportError(e.Error(),

IID_IRowsetChange,

pCurSObject->GetError(),

pCurSObject->GetErrorMessage()));

}

enum SError sfError = pCSFSession->GetError();

if (sfError != NO_SF_ERROR)

{

// error occurred durning query

return (SFReportError(DB_E_ERRORSINCOMMAND,IID_IRowsetChange,sfError,pCurSObject->GetErrorMessage()));

}

Thanks,

Bill Emerson

Hi,

When I use the Office Toolkit to do a GetDeleted call on Account,  I get back from the toolkit an array of Account objects instead of an array of DeletedRecords objects.  How do I access the deletedDate field since it doesn't appear in the returned Account object ?

Thanks,

Bill

Hi everyone,

I just put up a beta version some code I wrote to connect SQL Server and Salesforce.com.  If you would like to take a look at it, go to www.forceAmp.com and register for the beta program.  It is beta code, so set your expectations appropriately.

Bill Emerson

Message Edited by qman on 06-30-2005 04:22 PM

DBAmp is now open source and free ! If you are looking for a way to access Salesforce.com data via SQL SELECT statements or need to quickly replicate your Salesforce.com data into local SQL Server tables, check out the DBAmp open source project at www.forceamp.com. If you don't have SQL Server, you can download a free version from Microsoft called the SQL Server 2005 Express Edition and use it to host DBAmp. You can watch a Dreamforce presentation on DBAmp at http://www.crmsuccess.com/browse/content_detail.jsp?id=006300000034wbZAAQ&flid=02n300000000ID7AAM&slid=&tlid=02o300000000haWAAQ Thanks to all who participated in the beta program. Bill Emerson

Message Edited by qman on 10-28-2005 05:16 PM

Message Edited by qman on 10-28-2005 05:16 PM

DBAmp is now open source and free !
If you are looking for a way to access Salesforce.com data via SQL SELECT statements or need to quickly replicate your Salesforce.com data into local SQL Server tables, check out the DBAmp open source project at http://sourceforge.net/projects/dbamp .

If you don't have SQL Server, you can download a free version from Microsoft called the SQL Server 2005 Express Edition and use it to host DBAmp.

You can watch a Dreamforce presentation on DBAmp at http://www.crmsuccess.com/browse/content_detail.jsp?id=006300000034wbZAAQ&flid=02n300000000ID7AAM&slid=&tlid=02o300000000haWAAQ

Thanks to all who participated in the beta program.
Bill Emerson

Message Edited by qman on 10-17-2005 01:10 PM

I'm considering Rails for an app that will sync with a relational database. Are the data replication methods getUpdated and getDeleted available through ActiveSalesforce? Is getUserInfo, or some equivalent,
available through ActiveSalesforce?

Thanks in advance

I have to insert/update a large number of opportunities (several hundred to several thousand) on a daily basis.  There are 500,000+ opportunities stored in salesforce.  To make it worse, the financial system can't store the salesforce ID.  That means I can't use retrieve because I don't have the salesforce IDs.  So I'm stuck with query.

Each record from the financial system has a "sale number" which is stored in a custom field in salesforce.  What I need to do is something like this:

select <columnlist> from Opportunity where SaleNumber__c IN (sale number array)

I know SOQL doesn't support the IN keyword, so does anyone know of a better way to get this done?  What we have to do today is pull the ENTIRE list of opportunities and then do a local match to determine insert/update - big performance hog.

My real solution is to build an intermediate database that contains both the salesforce ID and the sale number, do a local match and then an upsert.  That's in the works, but will take longer.  In the meantime...

This sounds bad, but if I use this syntax:

select <columnlist> from Opportunity where (SaleNumber__c=1 OR SaleNumber__c=2 OR SaleNumber__c=3 OR...)

How many ORs can I use?  It could be a very long string of them.

I'm planning on taking nightly back-ups from Salesforce.com into a database (SQL Server). I have a couple questions regarding the export process:

1.   If I only want the deltas should I use the LastModified Date as the selection criteria to determine recenlty created or updated records in the last 24 hours?

2.  Should I use Salesforce.com's server date/time value as a starting point for determining the above. If yes,  is it possible to do a select statement to get this value (outside of the SOAP getServerTimeStamp())?

3.  Do folks generally convert the UTC date/time stamp to their local time zone before inserting the records?

4.   If new fields are added (or maybe updated) should I consider dropping my back-up table and re-creating it to address this case?

I'm sure there are other points I need to consider so I'm hopefully folks can provide some additional input.
BTW, I'm planning on using Pervasive's Business Integrator to do the nightly exports.

Thanks in advance
Keith

Need salesforce.com consultants local to Denver.  Must be available immediately. 

We have a java web application that replicates some of the Sforce Objects. The web application polls the Sforce site for changes when it receives a request. Sometimes many requests come to this web application within a short time interval.

Therefore our application's polling frequency can be less than 5 minutes at times. We have however limited this frequency to 1 minute. 

We use Sforce API 6.0. The API documentation recommends that the polling frequency should be more than 5 minutes and if the polling is too frequent Sforce built in controls will prevent the request.

Does Sforce web service prevent above type of requests?  We have not seen any errors thrown by Sforce in above instances. But sometime we notice that a few objects had not replicated correctly. Please advise us on the exact rules involved.

Thanks

Already hired someone.  Thanks for your interest.

Frank

Message Edited by FranksNickname on 03-03-2006 04:00 PM

I'm thinking about upgrading Karl's old ADO.NET provider to work as a ADO.NET 2.0 provider with batch update capability and VS Desgin support.

Is there any interest in the .NET community for a new version of the provider ?

Thanks,

Bill

Hi,
I have what appears to be a rather straightforward task but since I'm new to both .NET Web development and salesforce.com, I figured I'd ask before I get started.

We are creating a Web application that needs to show users a list of Salesforce Opportunities and allow them to make a selection. The selection will be stored in our own SQL Server tables along with other non salesforce related data that is entered on the screen.

Is this doable? From what I am reading I need to create and download the enterprise.wsdl. I also saw sample applications but wasn't sure which one was most appropriate for my needs. We are using vb.NET and Visual Studio 2003 Enterprise edition for our development.

Thanks in advance for your help.

Does the handleEmailMessage() method update the Status of a CASE if it attaches an EmailMessage object to an existing case?

My problem:

Our Reps each have a queue and the view of the Case Tab is set up to only list Cases that are not "CLOSED". I am noticing a scenario where a CASE got created with my custom EmailToCase Agent, the Rep replies to the email and then CLOSES the CASE. The person who receives the email then replies and the EmailToCase handleEmailMessage() method attached that reply EmailMessage to the existing case (as outlined in the documentation... which is exactly what we want), but the Status of the CASE does not change (which may be by design).

If so, any suggestions on how I could re-open the case by updating the status.

Thanks...