You need to sign in to do that
Don't have an account?
how to fetch data from SQL SERVER to Apex List collection
I have a requirement that before inserting data I need to look for NAMES(codes) that are avavilabe some on the web in SQL SERVER database
I mean I have my SQL SERVER database accessible on the web... I need to query that database(table) from Apex and get the names of all the codes availabe like and hold that in a list collection in apex...like
List [] String lstName = Select NAME from distributors;
(I mean in need to populate this list from SQL SERVER in apex.)
from here I can check if the incoming record has any of the name that is availabe in this list from SQL .. I will proceed with my code...
Please guide me is their a way to do so..its bascially etablishing connection between salesforce to SQL SERVER(or any other database).
Thanks in advance.
Sanjeev
I'm not an expert on SQL server web services, but this may help as a start: http://www.developer.com/net/asp/article.php/3767311/Creating-Native-Web-Services-in-SQL-Server.htm
For help on Apex callouts, please see "Apex Callouts" in this page: https://developer.salesforce.com/page/Apex_Web_Services_and_Callouts
Hi Shashank,
Basically my objective is to populate my List (Map) here filled with the data, from the third party database. So that I can further query this collection and take conditional desicion on this List(Map) collection.
How can we populate List (Map) in Apwx from third party database.
thanks in advance
Sanjeev