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.
Can you share with us what problem you are trying to solve? Also, please remember to contact us at support@OpenAccessSoftware.com for a prompt reply to any questions you may have.
The preview version allows read/write access to Salesforce using the SQL commands SELECT, UPDATE, DELETE, and INSERT. 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.
1) I downloaded the Driver. 2) Installed it with no problem. 3) Created new MS Access 2003 DB. 4) Linked all SFDC tables. 5) Open tables and viewed my data! 6) I haven't written any queries or reports yet, but that will be soon.
Would anyone know the proper procedures Insert records using this tool either using Insert Queries or VBA code? For example, how are Primary Keys generated, etc.
When you link a table in MS Access and then do an insert of a row, MS Access first submits an "INSERT INTO xyz..." statement and then immediately performs a SELECT .... WHERE ID is NULL. Our driver intercepts this and substitutes ID is NULL with ID=xxxx, where xxxx is the ID generated by Salesforce for the last record inserted on that connection. Here is the query that MS Access generates to read back all the fields for the record just inserted.
SELECT "Id","Name","Type","ParentId","BillingStreet","BillingCity","BillingState","BillingPostalCode","BillingCountry","ShippingStreet","ShippingCity","ShippingState","ShippingPostalCode","ShippingCountry","Phone","Fax","AccountNumber","Website","Sic","Industry","AnnualRevenue","NumberOfEmployees","Ownership","TickerSymbol","Description","Rating","Site","OwnerId","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","SystemModstamp","UpsellOpportunity__c","SLA__c","SLAExpirationDate__c","SLASerialNumber__c","NumberofLocations__c","Active__c","CustomerPriority__c" FROM "Salesforce"."Account" WHERE "Id" IS NULL
If you are writing VBA code then you first need to generate an INSERT statement that contains all the required fields, for example OwnerId, but does not specify value for the primary key filed ID. Then you need to execute a SELECT statement on that table with a query that retrieves all the columns you are interested in by specifying filter condition WHERE ID is NULL.
Yes, we have developed a ODBC driver for SalesForce
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
Can you share with us what problem you are trying to solve? Also, please remember to contact us at support@OpenAccessSoftware.com for a prompt reply to any questions you may have.
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/write access to Salesforce using the SQL commands SELECT, UPDATE, DELETE, and INSERT. 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
So far so good.
1) I downloaded the Driver.
2) Installed it with no problem.
3) Created new MS Access 2003 DB.
4) Linked all SFDC tables.
5) Open tables and viewed my data!
6) I haven't written any queries or reports yet, but that will be soon.
Would anyone know the proper procedures Insert records using this tool either using Insert Queries or VBA code? For example, how are Primary Keys generated, etc.
Thanks!
Mark
Portland, OR
Mark,
When you link a table in MS Access and then do an insert of a row, MS Access first submits an "INSERT INTO xyz..." statement and then immediately performs a SELECT .... WHERE ID is NULL. Our driver intercepts this and substitutes ID is NULL with ID=xxxx, where xxxx is the ID generated by Salesforce for the last record inserted on that connection. Here is the query that MS Access generates to read back all the fields for the record just inserted.
SELECT "Id","Name","Type","ParentId","BillingStreet","BillingCity","BillingState","BillingPostalCode","BillingCountry","ShippingStreet","ShippingCity","ShippingState","ShippingPostalCode","ShippingCountry","Phone","Fax","AccountNumber","Website","Sic","Industry","AnnualRevenue","NumberOfEmployees","Ownership","TickerSymbol","Description","Rating","Site","OwnerId","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","SystemModstamp","UpsellOpportunity__c","SLA__c","SLAExpirationDate__c","SLASerialNumber__c","NumberofLocations__c","Active__c","CustomerPriority__c" FROM "Salesforce"."Account" WHERE "Id" IS NULL
If you are writing VBA code then you first need to generate an INSERT statement that contains all the required fields, for example OwnerId, but does not specify value for the primary key filed ID. Then you need to execute a SELECT statement on that table with a query that retrieves all the columns you are interested in by specifying filter condition WHERE ID is NULL.