Hi Community!
I'm new to Oracle SOA Suite. I'm developing a Service Bus Application that takes some fields from Salesforce and map them to a csv file on a FTP server. I'm trying to design the mapping between the Salesforce Query Response Profile and the text target profile of the file to be put on the FTP server.
For the target profile I defined an xsd schema using the guided procedure when creating an FTP Business Service. For the source profile I chose one of the 3 schemas defined in the Salesforce enterprise.wsdl file and I selected the table that I needed to query (for example Contact table).
But when I finish to configure the XQuery Transformation and the software tries to load it, it becomes very very slow due to the RAM saturation and I must restart it because I can't modify anything.
I think that this is not the correct behavior of the program so I would like to know where I made a mistake. I probably imported the Salesforce source profile in a wrong way because the target profile has only two fields and I don't think that it is the reason of RAM saturation.
Can anyone help me explaining how I should define the Salesforce Query Response Profile as source of the XQuery transformation?
Thanks in advance