Data Migration among Sanboxes | Salesforce SOAP API

 

Data Migration among Sandboxes | Salesforce SOAP API

Setting up VS Code for the SOAP API and Moving Data From One Sandbox to another Sandbox.



Prerequisites.


This can be done with both enterprise and partner WSDL. In this blog, we are going to use the partner WSDL.



Follow the below steps to get the WSDL from your org.

  1. Go to Setup.



  1. In the Quick Find Box, Write API and Select API under Integrations.

            

        








  1. Now Click on Generate Enterprise WSDL  link.







  1. Now click on Generate icon to get the WSDL of your Org.


This will Generate the Org WSDL and show that on your browser screen. Copy that WSDL in any file (like ent.wsdl) and Save it. We will be using this WSDL to create STUB.




Generating Stub From WSDL.

  1. Click on this link to download uber.jar https://repo1.maven.org/maven2/com/force/api/force-wsc/53.1.0/force-wsc-53.1.0-uber.jar.

Or you can navigate through the website https://mvnrepository.com/artifact/com.force.api/force-wsc and download the jar from here.


  1. Open the terminal and use the below command to create a stub.

           Command Format :

 java -classpath force-wsc-xx.x.x-uber.jar        com.sforce.ws.tools.wsdlc wsdlname.wsdl stubname.jar

 

I have the wsdl  and wsdl.jar both in the same directory and terminal is opened in the same.

So the command in my case is. (It can be a bit different in you case).

java -classpath force-wsc-53.1.0-uber.jar com.sforce.ws.tools.wsdlc ent.wsdl wsdlFiles.jar


This will create a stub for you. This stub will be later used to communicate between orgs.




Creating a Java Project and Moving data between Sandboxes

  1. Open Command Palette in VS Code. 

            For Windows :  Press Ctrl  + Shift + P.

For Mac         :  Press Command + Shift + P.


For this hands-on tutorial, we don’t need any Build Tool. So you can Select No Build Tools


Select Project location and give this a name.


  1. Select Explorer in the VS Code and click on the + icon in the referenced libraries.


  1. On clicking the + icon, File Explorer will open. Select the jar that we created using WSDL and uber.jar.


Use the below Sample  Code  to move the data


.

import com.sforce.soap.enterprise.sobject.Account;

import com.sforce.soap.enterprise.Connector;

import com.sforce.soap.enterprise.EnterpriseConnection;

import com.sforce.soap.enterprise.Error;

import com.sforce.soap.enterprise.QueryResult;

import com.sforce.soap.enterprise.SaveResult;

import com.sforce.soap.enterprise.sobject.SObject;

import com.sforce.ws.ConnectionException;

import com.sforce.ws.ConnectorConfig;

 

 

 

public class App {

   //Credentials for the Source Org.

   public static final String  unameSource  = "Source Org Username";

   public static final String  passSource   = "Source Org Password";

  

   //Credentials for the Target Org.

   public static final String  unameTarget   = "Target Org Username";

   public static final String  passTarget    = "Target Org Password";

 

   //Enterprise Connection Objects.

   public static EnterpriseConnection enterConnSource;

   public static EnterpriseConnection enterConnTarget;

 

   public static EnterpriseConnection doLoginEnterprise(String uname,String password ){

       ConnectorConfig config = new ConnectorConfig();

       config.setUsername(uname);

       config.setPassword(password);

       EnterpriseConnection enterConn = null;

      

       try {

           enterConn = Connector.newConnection(config);

           System.out.println("Connected ....");

      

       }catch(ConnectionException e) {

          e.printStackTrace();

          System.out.println("ERROR Occured,Not Connected....");

       }

       return enterConn;

   }

 

   public static void moveData(){

       try {

           //Querying the Data that we need to Move

           String query = "SELECT Name,Type FROM Account Where Name='Avengers' ";

           QueryResult qr = enterConnSource.query(query);

           //Getting  Queried Records.

           SObject records[] = qr.getRecords();

          

           SaveResult[] srArray = enterConnTarget.create(records);

           for(SaveResult sr:srArray ){

               if(sr.getSuccess()) {

                   System.out.println("Record Id is : "+sr.getId());

               }else {

                   for(Error err: sr.getErrors()) {

                       System.out.println(err.getMessage());

                   }

               }   

          }

       }catch(ConnectionException e){

           e.printStackTrace();

       }

   }

 

   public static void main(String[] args) throws Exception {

       //Connection to the Source Org.

       enterConnSource = doLoginEnterprise(unameSource,passSource);

      

       //Connection to the Target Org.

       enterConnTarget = doLoginEnterprise(unameTarget,passTarget);

       moveData();

   }

}

 



Run the Program and the Records Filtered will be moved from  Source Sandbox to target Sandbox.

Comments

Post a Comment

Popular posts from this blog

Salesforce CI/CD Pipeline | Bitbucket

Image
Salesforce CI/CD Pipeline | Bitbucket In this article, we will be setting up Bitbucket CI/CD Pipeline for Salesforce. Prerequisites Salesforce Extension Pack for the VS Code Salesforce CLI Supported Java OpenSSL CLI ( To check if it is installed, Use the command openssl version, if OpenSSL is installed, it will print the OpenSSL version in the terminal).   Setting up Bitbucket for Salesforce Project Create a bitbucket Account. You can use this link for signing up  Login to the bitbucket Account you just signed up for. Create a Bitbucket Repository.  Go to  Home -> Repository. Now  Click on the Create Repository to create the Bit Bucket Repository.    Fill in all the details on the new screen. Then click on Create repository button at the bottom. (I will be using the name sfdx-demo as the repository name ,  I recommend you use the same repository name. So that you can follow along and used the same commands that will be in the article). Now...
Read more

Salesforce ANT Setup for MAC

Ant setup for MAC Download Apache ANT Latest  version from    https://ant.apache.org/bindownload.cgi  (download zip file.  Extract the zip file in Desktop. Make sure you have Java 8 or Later installed in the System. Now open the terminal and type vim .profile . Press "i" key, So that you will be in Insert mode. Open Terminal and Type.   export ANT_HOME=/Users/mukul/Desktop/apache-ant-1.19.6. ( Make sure you change the ANT_HOME according to your machine.) export JAVA_HOME=$(/usr/libexec/java_home). export PATH=$PATH:$ANT_HOME/bin export PATH=$PATH:$JAVA_HOME/bin. Press Esc Key. Enter :wq and press " Enter " key. Do the same for vim .bash_profile and for vim .zshenv as well. Close and reopen terminal and type - ant -version . It should display the version of the file. Download the ANT. Download ant-salesforce .zip file from location https://developer.salesforce.com/docs/atlas.en-us.daas.meta/daas/forcemigrationtool_install.htm Extract the zip fil...
Read more

Salesforce FLS Exporter

Image
Salesforce FLS Exporter Hi, Greetings of the Day. Many times we comes across a requirement to Export field Permissions for Profiles/Permission Set.   In this article we are going to discuss a unmanaged Package that we can use to FLS for Profiles / Permission Set. Steps Install the Unmanaged Package in the System. Link to install Package  Go to FLS Exporter  Lightning Page. Select Profiles, Permission Sets, Object that you want to Export. Click on the Export Data Button. Output Format Profile : A file will be generated with the name ProfileName_Profile.xlsx Permission Set : A file will be generated with the name PermissionSetName_PermissionSet.xlsx. Each excel sheet will be containg tabs for every object. Screenshot of the excel File. Hope this is helpful, Thank you !
Read more