You need to sign in to do that
Don't have an account?
Jyothy Lakshmy
Get XML from external system
Hi all,
I have a custom object?(card) in salesforce with field (service order) . I would like to get information from oracle db that match this service order.
What approach would be better?
What about service calls?
I am baby on this case of integration?
Can anybody help me?
If i do REST api,
i have some questions.
I could find a blog :-
https://developer.salesforce.com/blogs/developer-relations/2013/08/integrating-force-com-using-xml-in-apex.html
Can i do something like this?
1. When the call is made to the XML server, is the web browser on the user's PC making the call or is the SalesForce.com server making the call?
2. Is it makes a difference in how we will need to navigate around the firewall issue?
3. Which is good to use SOAP / REST?
4. What is difference between them?
Thanks in advance.
I have a custom object?(card) in salesforce with field (service order) . I would like to get information from oracle db that match this service order.
What approach would be better?
What about service calls?
I am baby on this case of integration?
Can anybody help me?
If i do REST api,
i have some questions.
I could find a blog :-
https://developer.salesforce.com/blogs/developer-relations/2013/08/integrating-force-com-using-xml-in-apex.html
Can i do something like this?
1. When the call is made to the XML server, is the web browser on the user's PC making the call or is the SalesForce.com server making the call?
2. Is it makes a difference in how we will need to navigate around the firewall issue?
3. Which is good to use SOAP / REST?
4. What is difference between them?
Thanks in advance.
Help: https://help.salesforce.com/apex/HTViewHelpDoc?id=code_wsdl_to_package.htm&language=en (https://help.salesforce.com/apex/HTViewHelpDoc?id=code_wsdl_to_package.htm&language=en)
http://www.jitendrazaa.com/blog/salesforce/consuming-external-webservice-in-apex/
If you are using only Oracle DB without any front end application, then loading data using DataLoader is the best option.You can extract data from oracle DB in CSV format and then use the same file to load data in salesforce. There is a way to automate dataloader also.Please refer to this blog -
https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line
Otherwise you can use Apache axis or dot Net application to build webservices.Using websercices with Oracle DB alone is little bit tricky.
Please let me know if this helps.
Regards,
Shashi
I would like to add a button to display the salesorder number and an call activation button in detail page of Card. On click the activation button, request Oracle DB to get product information that match salesorder number. this is what exactly i need.
I am not clear about the request from the apex class to Oracle DB and recieve the XML response. Can i get a clear ides on this request and response?
What are the parameters need to be passed to the server?
Whithout using Remote Site Setting, can i request simply by the apex method that will call when click the button on popup?
Firewall dependancy on this case?
How can i pass security parameters to Oracle?
Is that needed?
Difference between can from browser and Salesforce server?
Awaiting reply.
You can achieve this using a webservices - either a SOAP based or REST. You can contact the Oracle DBA who is the owner of this database. As I mentioned using SOAP based Webservices in oracle DB without using any front-end application is tricky. You may need assistance from DBA. Better you should implement using a language either Java (e.g. Apache Axis) or .NET.
Please let me know if this is helpful.
Regards,
Shashi
hi please someone help me on my concerns
https://developer.salesforce.com/forums/ForumsMain?id=9060G000000BhQnQAK
Thanks!