Sunday, January 30, 2011

Automate Data Import process in Salesforce.com

Other than the Data Import, DataLoader and Salesforce Data Loader Command Line Interface Tool, which are Provided by Salesforce.com, which as per the project requirement can be used. Few of the techniques which i thought will help to automate the data Import process, are described below:

1. Automated Push Approach: Automated Push Approach will have a any lanugaue Window Service application running on the server machine outside of the Salesforce Environment. This Window Service will call Salesforce Data Loader Command Line Interface Tool to upload data into Salesforce.com object(s).

2. Automated Pull Approach: Cloud Job can be created and scheduled inside the Salesfoce App. object. Implicitly Cloud Job will call an External Web Service or Application. This External Web Service or Application will be outside the Cloud Environment and will be hosted on Remote Server. Scheduler will import the data into Salesfoce.com App.

3. Http Request / Response: Can create a Http Request to the FTP / Remote server. Can handle the response using either of HttpRequest and HttpResponse Apex Class

4. Cloud Approach: A User Interface will have “Import Data” functionality in Cloud Application, where user can browse data file and upload which will trigger data import into Cloud Application.

Hope this approaches help in automating data into Salesforce.com for Standard or Custom objects.

3 comments:

  1. Based in India, Udehra Mechanical Works is a prominent manufacturer and suppliers of huge variety of high tensile industrial fasteners like nuts and bolts which are supplied to our reputed clients.

    fastener manufacturer

    ReplyDelete
  2. Suppliers and manufacturers of B-7 studs, 2-H nuts offered by Pankaj International Suppliers, India. Contact Us:
    Pankaj International
    B-40/III, Phase V, Focal Point, LUDHIANA-141010 (INDIA)
    Phone : +91-161-2677676 Fax : +91-161-2676976
    Cell: +91-094634-00401
    E-mail : sales@pankajinternational.com
    accounts@pankajinternational.com
    quality@pankajinternational.com
    production@pankajinternational.com
    administration@pankajinternational.com
    gm@pankajinternational.com
    pankaj@pankajinternational.com
    Skype ID : pankaj.gupta11

    High tensile bolts


















    ReplyDelete
  3. A group of highly dedicated and experienced employees form a dynamic team, The manufacture of Gear Cutting Tools, Broaches and Allied Products. Address :B-22, Focal Point, Patiala - 147004 (Pb.) India. Contact Person :B.N. Mittal Mobile :+91-98142 04856, 98141 87540, 9914678555, 9855003363 Phone :+91-175-3290772 Fax :+91-175-2232772, 2233181 E-mail :superhobs@gmail.com.

    Metal Slitting














    ReplyDelete