Dear All,

You can query/update salseforce.com direct from oracle pl/sql block.

eebpage of the project: http://code.google.com/p/plsqlsoap/

some features:

• create oracle table on the fly.
• create unique indexes and prmary keys
• generic sql from salesforce
• http communication compression
• load oracle table from salesforce
• on salesforce schema changes recreate the oracle schema
• autocommit possibilities for batches
• SOAP call support: describeGlobal , describeLayout, describeSObject, describeTabs,getServerTimestamp,getUserInfo,query,queryAll,queryMore
• http proxy support

If you have any question and/or feature requests do not hesitate contact me

Regards
Gergo
gergo@bacskai.hu

Dear All,

I have made some bugfix on the package.
Now you can use increment data load from salesforce to oracle table or you can make your custom query.

The code can be found here: http://code.google.com/p/plsqlsoap/

Regards
Gergo
gergo@bacskai.hu

Dear All,

Webpage of the project: http://code.google.com/p/plsqlsoap/

New version in the repository.

    * General soap calls from salesforce
    * Full Object copy from salesforce to oracle
    * Supported SOAP calls: describeGlobal , describeLayout, describeSObject, describeTabs,getServerTimestamp,getUserInfo,query,queryAll,queryMore

I have tested with Oracle Database 10g Release 10.2.0.1.0 and PL/SQL Release 10.2.0.1.0.

If you have any question and/or feature requests do not hesitate contact me

Regards
Gergo
gergo@bacskai.hu

Hi All,

I have made a pl/sql package for salesforce queries. http://code.google.com/p/plsqlsoap/

Simply you can select like this from oracle:

select extractvalue(sf_xml_return,'//sf:Id','xmlns:sf="urn:sobject.enterprise.soap.sforce.com"') Id
from table(OLAP_XMLA_SF5.SF_CALL ('SELECT Id FROM Opportunity'));

I will improve the code with better compression and session handling but now it works for any salesforce replication.

I have tested with Oracle Database 10g Release 10.2.0.1.0 and PL/SQL Release 10.2.0.1.0.

If you have any question and/or feature requests do not hesitate contact me

Have fun
Gergo
gergo@bacskai.hu



Message Edited by gbacskai on 04-29-2008 08:14 AM

Dear All,

Webpage of the project: http://code.google.com/p/plsqlsoap/

New version in the repository.

    * General soap calls from salesforce
    * Full Object copy from salesforce to oracle
    * Supported SOAP calls: describeGlobal , describeLayout, describeSObject, describeTabs,getServerTimestamp,getUserInfo,query,queryAll,queryMore

I have tested with Oracle Database 10g Release 10.2.0.1.0 and PL/SQL Release 10.2.0.1.0.

If you have any question and/or feature requests do not hesitate contact me

Regards
Gergo
gergo@bacskai.hu

Hi All,

I have made a pl/sql package for salesforce queries. http://code.google.com/p/plsqlsoap/

Simply you can select like this from oracle:

select extractvalue(sf_xml_return,'//sf:Id','xmlns:sf="urn:sobject.enterprise.soap.sforce.com"') Id
from table(OLAP_XMLA_SF5.SF_CALL ('SELECT Id FROM Opportunity'));

I will improve the code with better compression and session handling but now it works for any salesforce replication.

I have tested with Oracle Database 10g Release 10.2.0.1.0 and PL/SQL Release 10.2.0.1.0.

If you have any question and/or feature requests do not hesitate contact me

Have fun
Gergo
gergo@bacskai.hu



Message Edited by gbacskai on 04-29-2008 08:14 AM