Data Loader VS Batch Apex
May25

Data Loader VS Batch Apex

Data, data, and loads of data!! Would you still prefer to migrate this lot of huge data in the old traditional way by creating the number of excel sheets, matching it, again and again, to avoid any errors, giving strain to your eyes and wasting much of your time? Let’s suppose somehow you managed to import million of records and then end up with inserting few wrong values. Alas, now for sure you have to do it all over again. If we are living in a high-tech world then why would you want to do things manually when it can be done programmatically. Yup, we can insert a lot of data using just a Batch Apex. Though both Data Loader and Batch Apex has its own advantage in their own ways but you have to be judgemental to use it wisely. Let’s throw some light on both of these. DATA LOADER- What’s this??? Before we waste any time, let’s first understand what Data Loader is. Simple but yet powerful, it’s a Desktop tool to migrate data from two IT systems. It generally focuses more on migrating data in between two different environments. Consider an example where you want to migrate a .csv file from your old legacy system to Salesforce cloud-based system, this can easily be done via Data Loader. Other Use Case Scenario: Want to have a daily backup of your customer records. Importing records of emails that you want to update for lead comparison. Importing a report file that is been generated in third party marketing automation tool that you want to link with Salesforce accounts. How It Function?? When you import data, Data Loader first reads it, then extracts it and lastly loads data from CSV files or database connections. See operations below:     DATA LOADER- Advantage Data loader has too many advantages in its own way: The first and the foremost advantage is its automation process for complete data migration & yes! it’s hassle free. It helps you insert, export, update and delete data. One can perform DML Operations on up to 5 million records. It is an easy-to-use GUI-based interface. Drag and drop field mapping is one of its features. Detailed files showing success and error messages make it more easy to use. It supports Windows or Mac. BATCH APEX- What’s this??? Large sets of data is not a piece of cake for Data Loader in any way, It’s when Batch Apex comes into the scene. It generally focuses on processing bulk data within SFDC. It is easy to use with large volume set of data for migration. What one needs to do is...

Read More
Salesforce Web Service Testing Tool
May06

Salesforce Web Service Testing Tool

WEB SERVICES Web service or API is a collection of procedures or software components that help an application to interact or perform some process/transaction by forming a connection between other application or server. There are basically two types of web service – REST and SOAP to drive the communication of data and information over internet protocol. Two specifications for Web Services are illustrated in this section: SOAP, REST SOAP SOAP was originally part of the specification that included the Web Services Description Language (WSDL) and Universal Description, Discovery, and Integration (UDDI).It is an XML-based protocol for accessing web services. SOAP defines a standard communication protocol (set of rules) specification for XML-based message exchange. SOAP uses different transport protocols, such as HTTP and SMTP. The standard protocol HTTP makes it easier for SOAP model to tunnel across firewalls and proxies without any modifications to the SOAP protocol. SOAP can sometimes be slower than middleware technologies like CORBA or ICE due to its verbose XML format. SOAP messages are hard-coded or generated without the use of a repository. The interaction is illustrated in the figure below.   Representation State Transfer (REST) Representation State Transfer (REST) appeals to developers because it has a simpler style that makes it easier to use than SOAP. It also less verbose so that less volume is sent when communicating. REST web service permits different data format such as Plain Text, HTML, XML, and JSON. REST describes a set of architectural principles by which data can be transmitted over a standardized interface (such as HTTP). REST does not contain an additional messaging layer and focuses on design rules for creating stateless services. A client can access the resource using the unique URI and a representation of the resource is returned. With each new resource representation, the client is said to transfer state. While accessing RESTful resources with HTTP protocol, the URL of the resource serves as the resource identifier and GET, PUT, DELETE, POST and HEAD are the standard HTTP operations to be performed on that resource. The interaction is illustrated in the figure below. Web Services Testing Tool Salesforce supports the following  type of testing tools: Workbench POSTMAN APIGEE In this blog, I will let you know about how we can use POSTMAN testing tool. Before getting started with the postman, we need to keep following in mind: We should have a Class that will process the request and generates the response as per it. We need to have Connected App which will provide you the Consumer key and Consumer secret that will be used later for authentication. Lastly, the valid username and password with the...

Read More