Has anyone out there successfully integrated Quickbooks Online with Salesforce? I understand that it was possible with Quickbooks, but had not heard about Quickbooks Online. Thanks for your help!

Hi,

Is there a tool in AppExchange similar to DBAmp - to import objects/data into Oracle database 8i/9i? I tried DBAmp but that can import salesforce objects only to Microsoft SQL Server. So just wondering if there is a similar tool that support Oracle 8x/9x databases.

Your response is very much appreciated.

Thanks and regards,
Ambili

Hi Folks,
 
I'm working on a project which is considering trying to use SFDC purely as a database -- nobody cares about its CRM abilities, or user interface.
 
The intention is to use (as yet undetermined) generic forms engines and generic reporting tools as the front end to this SFDC database.
 
A casual look at DBAmp (as a Linked Server in SQL Server) suggests that it could be used to glue these front end tools to SFDC, but a closer reading of the documentation suggests that this will incur large performance issues as the database grows in size -- because of the way that SQL Server will first pull down the entire content of the table being queried or updated.
 
I recognise that the solution to this is to rewrite the query to use the SQL Server's 'OPENQUERY' syntax, but it seems (to me) highly unlikely that an off-the-shelf forms engine or reporting tool would be capable of generating SQL with this 'OPENQUERY' syntax.
 
Have you encountered this sort of use of SFDC before? Is there something that I'm missing?
 
If there isn't any obvious solution to the issue above, I guess our options are:
 
- Using DBAmp to replicate data down to SQL Server, and just using the 'generic' tools against SQL Server
- Finding SFDC / DBAmp 'aware' tools for the forms and reporting engines (any pointers?)
- Not use SFDC like this
 
Has anybody been down this path before? Any suggestions?
 
Thanks,
Kerry