+ Start a Discussion
drober01drober01 

ODBC?

Is there a way to connect to Salesforce via ODBC?
adamgadamg
No, although in theory it would be possible for someone to write a driver that allowed it.
openaccessopenaccess

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

fifedogfifedog
Good Lord! I can't believe this timing! If this can do what you say you're a life saver!
openaccessopenaccess

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.

openaccessopenaccess

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

markbrusomarkbruso

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

openaccessopenaccess

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.

 

Konrad ZawelKonrad Zawel
Try Skyvia (https://skyvia.com/connect/salesforce-connect), it is a no code and easy to use data integration tool.