Skyvva is a commercial software integration product that facilitates data integration. It is s a client application for the bulk import or export of data. SKYVVA´s Dataloader is a native Salesforce App and is designed to integrate data supporting CSV/XML format via a manual file upload. It is simple, intuitive and powerful to built integration in minutes. It is a Config&Click graphical mapping tool.
Required Tools:
- Salesforce Organisation.
- Agent application.
- SoapUI application
- Postman
Here Tutorials are guided learning paths through projects that help you cover the most ground in the shortest amount of time.
Basic of Skyvva:
Learn about the Salesforce developer org.
– Enter the given link in browser: https://developer.salesforce.com/signup
– Enter your contact information.
– Enter a unique username.
– Submit the form, and wait for your welcome email.
– In the welcome email, click the link to set your password.
Learn about the Installation of Skyvva how to install.
The purpose is to introduce the product or component to be installed. This guide covers the installation of the system and its related components like domain creation and updates Skyvva license key. We can get an installation link from the release note.
– How to install SKYVVA Integration Suite?
Learn about the Integration and how to create.
This is the first step and the basic to understand the concept of the SKYVVA integration Cloud. It describes the main SKYVVA object called “Integration”. SKYVVA integration is such a concept to create a container or folder to keep related interface together. So here Integration is a logical folder or group to hold interfaces belonging to the same business context.
– What is an integration and how to create it?
Learn about the Interface and how to use.
The interface is the second main object in SKYVVA after the integration. Interface describes the structure of data to exchange between Salesforce and other applications. We have two types of Interface:
- Inbound Interface
- Outbound Interface
– What is an interface and how to create it?
Learn about Skyvva mapping and how to use skyvva mapping tool.
SKYVVA’s Mapping tool is a tool to map other system object and field with SFDC object field. Here we will map source fields with target object fields. Source fields are nothing but our Istructure.
– How to use formulas in mapping?
Learn about Skyvva Dataloader and how to upload data manually.
SKYVVA´s Dataloader is designed to integrate data supporting CSV/XML format via a manual file upload. Skyvva data loader use to upsert, insert, update, delete, or export Salesforce records.
– How to upload Account Data using Data Loader?
– How to import flat XML file?
Learn about Message Monitoring and how to use the message board.
Message Monitoring is used to check the integration result after processing the Inbound or Outbound interface. The integration result includes Pending, Failed, Completed, Cancelled status and the reason why it failed. Additionally, we can know the real Sobject is integrated successfully with completed status.
Learn about Message reprocessing and how to Reprocess fail and pending message.
Fail or pending message can be reprocessed by manually or automatically. Automatic reprocessing is done by the “MessageReprocess” job.
– How to use message reprocessing?
– How to use message reprocessing per integration?
Learn about Message type and how to create message type with different file formats?
The message type is a structure definition that is stored in the Repository. We can manually create a free defined message type or create it by uploading file functionality. The message type can be resided in a WSDL, in SAP IDoc, SAP Bapi, etc… It can be stored in a file in CSV, XML, JSON, or other formats.
– How to create free defined message type?
– How to create message type, for example: using WSDL or XSD…?
– How to process message type based Interface?
Learn about Hierarchical data import and how to create parent-child interface.
To arrange interfaces in order means hierarchical interface. It is a structure in which interfaces are ranked according to levels of importance. In hierarchical Interfaces, one interface is a parent’s of another interface. It means that the child interface inherited External ID from its parent’s interface. For example, the Account interface is the parent’s contact interface because of Contact inherited External ID from Account.
– How to create hierarchical interface using VLOOKUP
– How to create hierarchical interface using Foreign Key?
– How to use tree mapping concept to create hierarchical interfaces?
– How to import hierarchical xml file?
– How to upload account, contact and asset data in a CSV file in a step according to Salesforce?
Advance of Skyvva
Learn about Skyvva workflow and how to use the formula in workflow.
Skyvva workflow rule define Rule and Condition based processing for interfaces. It controls the flow of interface processing with conditions. Workflow is used to push the database on condition, and the condition bases on Interfaces.
– How to use formulas in workflows?
– What is the Workflow transaction and how to use it?
– What is new in workflow with the Spring ’19 release
Learn about Batch processing and how to use batch control board.
Batch Control Board is a place where you can monitor Inbound Processing, Interfaces, Queues and Schedulers. Each tab holds a different function. Batch Control Board is using for mass data which is more than 5000.
– How to use Batch Control Board?
– How to use batch processing for inbound interfaces?
– How to speed up batch processing?
Learn about Bulk processing and how to use bulk control board.
Bulk Control Board is a place where you can monitor Inbound Processing, Interfaces, and Schedulers. These tabs are using for bulk processing performance. Bulk Control Board is using for mass data. SKYVVA Bulk Interface Processing is an interface uses for running bulk attachments. When you have any data, using Bulk Interface Processing is necessary (over 5000 records).
– How to use Bulk Control Board
– How to use bulk processing for inbound interfaces?
– What is the difference between the bulk mode supported in Skyvva?
– SKYVVA bulk interface processing
– What is the Auto-Switch mode and when to use it?
Learn about different mode supported for inbound processing
SKYVVA provide a different mode for inbound processing. Using this variety of modes we can integrate all kinds of data into salesforce. You can integrate data in different modes including Synchronous, Asynchronous, Batch Processing, Bulk Processing(SKYVVA Bulk and SFDC Bulk), and Automatic switch.
Learn about Skyva Adapter and how to use Skyvva adapter.
An adapter is a device for connecting pieces of equipment that cannot connect directly. We can use an adapter to transfer data to the external system. It provides the interface between a computer and a network connection. Skyvva provide different type of adapters. For example, File Adapter ( CSV, Excel, XML), JDBC Adapter (ORACLE, SQLServer, MySQL, MsAcess), FTP/SFTP Adapter, HTTP, EMAIL, SFDATALOADER, SAP-R/3, SFDC2SAPPI, Data Loader, REST, Soap, Force2Force Adapter.
– How to use file and ftp/sftp adapter?
– How to create SOAP interface using the SOAP adapter?
– How to create REST interface using REST adapter?
– How to use Mule skyvva adapter?
– How to use the REST adapter to consume Google API?
Learn about CDC processing and how to use the CDC control board.
CDC Control Board is a place where you can monitor Change Pointer, Interfaces and Scheduler. These taps added to make thing easier for you and they have a different function. we use this CDC processing for the outbound interface. CDC is made up of two components, the CDD, and the CDT. CDC stands for Change Data Detection and CDT is stand for Change Data Transfer. These two components have different functionality.
– How to use CDC Control Board?
– What is CDC and how to configure it?
– How to create change record using Process Builder?
Learn about real-time outbound processing and how to create it.
Real-time outbound interface we can do in different way i.e Using a button, Using trigger, Using the process builder. This feature use our invokeCallout2() method. This method support SAP, SAP-PI, SAP-R/3, SFDC2SAPPI, SOAP, REST adapter types. The response could be a text of JSON, XML, List<Map<String, String>> based on given flag parameters in CallOutControl and Apex of each adapter handle setting when executing callout.
– How to build real-time outbound interface?
– How to do invoke callout using Queueable mode?
– How to do invoke callout by using Auto mode?
Learn about SKYVVA Scheduler and how to use it.
SKYVVA Schedulers is a program that starts and handles job automatically. Each scheduler has a different purpose. These functions include Agent Scheduler, Basket Processing Scheduler, Bulk Processing Scheduler, CDD&CDT Scheduler, doMaintenance Scheduler, Message Reprocessing Scheduler, Basket Reprocessing Scheduler, and Checker Scheduler.
– Overview of SKYVVA Scheduler
Learn about SKYVVA soap and rest api and how to use it.
SOAP-based APIs are designed to create, recover, update and delete records like accounts, passwords, leads, and custom objects. REST is basically an architectural style of the web services that work as a channel of communication between different computers or systems on the internet
– Overview of SKYVVA soap and rest api
Learn about interface group and how to use it
Interface group is a unit to group logical interfaces together. For example, you can group interfaces which are related to each other e.g. Account and Contact to one interface group. Interface group is the object user define at configuration time.
– What is an interface group and in which case is it used?
Learn about queues and how to use it
Queue is a dynamic object, which created automatically based on the interface group. You have to remember if you do not define an interface group SKYVVA will create a default interface group with the name “skyvva_DefaultIG”. Each interface group will be created queues.
– What are queues and where is it used?
Artikel
- 1. What is Salesforce?
- 2. What is SKYVVA?
- 3. SKYVVA Integration Suite – Installation?
- 4. What is an integration and how to create it?
- 5. What is an interface and how to create it?
- 6. How to use mapping?
- 7. How to upload Account Data using data Loader?
- 8. How to import flat xml file?
- 9. Message Monitoring
- 10. How to use message reprocessing?
- 11. What is the Workflow transaction and how to use it?
- 12. What is new in workflow with the Spring ’19 release?
- 13. What is hierarchical interface?
- 13.1 How to create hierarchical interface using VLOOKUP
- 14.2 How to create hierarchical interface using Foreign Key?
- 13.3 How to upload account, contact and asset data in a CSV file in a step according to Salesforce?
- 13.4 How to import hierarchical xml file?
- 13.5 How to use tree mapping concept to create hierarchical interfaces?
- 14. How to use Batch Control Board
- 15. How to use Bulk Control Board
- 16. When to use synchronous, batch or bulk interface?
- 17. How to use CDC Control Board
- 18. How to configure Alerting?
- 19. How to configure Message and logs deletion?
- 20. Overview of SKYVVA Scheduler
- 21. What is message type?
- 21.1 How to use message type?
- 21.2 How to create free defined message type?
- 22.3 How to process message type based Interface?
- 21.4 How to create Trigger on MsgTypeRel?
- 21.5 How to create message type from different file format as xsd, json schema, wsdl 1.1 & 2.0, swagger 2.0 and openAPI 3.x?
- 21.6 How to create tree hold in hierarchical message type?
- 21.7 How to create Message Type from Salesforce sObject?
- 21.8 How to create Message Type from SKYVVA Business Object?
- 22. Overview of SKYVVA Soap and Rest API
- 23. How to use Agent Control Board
- 24. How to use streaming api with Agent?
- 25. How to create an adapter in Agent?
- 26. Overview of existing Skyvva adapters
- 27. What is an external Id and how to use it to handle correct data update with an interface?
- 28. What are the differences between the mapping modes?
- 29. What is an interface group and in which case is it used?
- 30. Different way how to invoke outbound interface
- 31. What are queues and where is it used?
- 32. Formula reference guide?
- 33. How to do Hierarchical mapping?
- 34. How to use Automated Report?
- 35. How to do invoke callout using Queueable mode?
- 36. How to Export data without header for Agent component ?
- 37. How to Import XML file Agent to Salesforce ?
- 38. How to import hierarchical data using xml and csv file?
- 39. What is the Auto-Switch mode and when to use it?
- 40. How to build real-time outbound interface?
- 41. What to do after a instance refresh?
- 42. How to Uninstall SKYVVA Agent?
- 43. How to Delete Messages with Bulk API
- 44. How to use the Message Reprocessing scheduler per integration, per interface group and per interface?
- 45. How to export the Metadata in different format as xsd, XSD (Response for V3 Inbound), json schema, WSDL 1.1, swagger 2.0/OpenAPI 2.0 and openApi 3?
- 46. What is the soap template message type?
- 47. What is the rest template message type?
- 48. How to use the CDD and CDT with the different scheduler per integration, per interface group and per interface?
- 49. How to pass raw data to custom class for processing with custom code?
- 50. What is the operation type Upsert Auto External ID, Update Auto External ID and Delete Auto External ID?
- 51. What is the operation query and pullQuery and what is the difference?
- 52. How to use the searchService to build the interface to query data from Salesforce?
- 53. How to load mass data using bulk api using Agent?
- 54. What is the different init-operation for the chained interface?
- 55: What are the different bulk mode supported?
- 56. How to generate SOQL statement for the outbound interface?
- 57. What is the InterfaceExecution Scheduler and when to use it?
- 58. What is the different posting behavior for the inbound interface?
- 59. How use conversion table as mapping formula?
- 60.What is the mode By-pass the message layer and when to use it?
- 61. How to publish platform event using the inbound interface?
- 62. What is the difference between normal and chained interface?
- 63. How to subscribe Salesforce Platform Event created by SKYVVA inbound interface?
- 64. How to use the operation query and transform the result set using the mapping tool?
- 65. Different ways to add custom logic for the inbound processing.
- 66. How to use the Salesforce CDC change event to send data out with the SKYVVA API?
- 67. How to create message type from the Database table, view, and stored procedure?
- 68. How to use the API invokeCallout2() to pass data from the screen and apex class?
- 69. How to enhance the response of the inbound synchronous interface to have a custom-defined message type?
- 70. How to use apex trigger to send real time data change to Agent?
- 71. How to use Data capture functionality Process Builder with Agent?
- 72. How to use LAST_INTERFACE_DATETIME() function?
- 73. How to use Agent Control Board (old) Version 3.0 AWS?
- 74. How to use apex class ?
- 75. Database Adapter
- 76. How to use FTP Adapter with Agent Control Board (old) ?
- 77.How to import Base64 String to Object Attachment in Salesforce with Agent Control Board (Old)?
- 78.How to import base 64 String data to Object ContentVersion in Salesforcewith Agent Control Board (Old)?
- 79.How to import attachment file to Account Using ContentVersion?
- 80. How to use File Adapter with Agent Control Board (old) ?
- 81.What is the CDD (Change Data Detection) and how does it work?
- 82. How to call store procedure by handling the response using Agent?
- 83. How is the Outbound interface using Message Type through Agent Control Board for JDBC Adapter (SQLServer)?
- 84. How to use Interface group in Agent Control Board (old)?
- 85. How does the new version 3 of inbound processing works?
- 86. How to push data to the Database using the new Agent
- 86.1 How to do insert operation using Synchronous and Asynchronous outbound interface?
- 86.2 How to do update operation using Synchronous and Asynchronous outbound interface?
- 86.3 How to do delete operation using Synchronous and Asynchronous outbound interface?
- 86.4 How to do Select operation using Synchronous and Asynchronous outbound interface?
- 87. How to add filter condition on “Set context” in mapping?
- 88. Agent Kafka Adapter
- 89. How to use the New Agent File adapter?
- 90. How to use Agent Control Board (New)?
- 91. How to import openAPI 3.x to create message type?
- 92. How to use Quick Action?
- 93. Installing CA-Signed certificate for Agent Service (https)
- 94. Enhancement handling fault response message with V3.
- 95. How to use Log and Log Configuration Tab on Agent Control Board ?
- 96. How to Import Metadata from Agent Control Board ?
- 97. Agent Pulsar adapter
- 98.Agent SOAP Adapter
- 99. How to use Cache Monitoring on Agent Control Board ?
- 100. How to use Agent cache on Agent Control Board?
- 101. Agent REST Adapter
- 102. How to install Agent 3.0 for Windows ?
- 103. How to install Agent 3.0 for Linux ?
- 104. How to use File Adapter (FileZilla Client & Server) with Agent Control Board for Consumer?
- 105. Agent Database Inbound Adapter
- 106. Agent File Adapter
- 107. How to use File Adapter (FileZilla Client & Server) with Agent Control Board for Producer?
- 108. What is Streaming API for the new agent?
- 109. How to call Stored Procedure on new Agent?
- 110. How to use the Agent on a local PC with a public IP-Address?
- 111. How to run inbound interface through the manually and scheduler?
- 112. How to run inbound interface group through the manually and scheduler?
- 113. How user can import business and attachments that are embedded in one file (Account)?
- 114. How user can import business and attachments that are embedded in one file (ContentVersion) ?
- Introduction
- How to Import CSV using the Data Loader
- 115.2 How to import XML using the Data Loader?
- 115.3 How to export csv data using the Data Loader?
- 115.4 How to export XML data using the Data Loader?
- 115.5 How to import JSON data using the Data Loader?
- 115.6 .How to export JSON data using the Data Loader?
- 115.7 How to Use Data Loader in SKYVVA ?
- 116. Google Pub/Sub Adapter.
- 117. Outbound Attachment SF to Agent (FTP)
- 118. How to use the REST V4 API to push data to skyvva?
- 119. How to develop outbound interface to publish data into the RabitMQ queue?
- 120. How to develop inbound interface to consume message from RabitMQ queue?
- 121. How to develop inbound interface to consume message from ActiveMQ queue?
- 122. How to develop outbound interface to publish data into the ActiveMQ queue?
- 123. JMS Adapter
- 124. How to use the REST v4 API to push data to Agent?
- 125. How to run the outbound interface through the manually or scheduler?
- 126. How to use SAP Control Borad?
- 127. How to use SKYVVA API?
- 128. How to use Import SAP Metadata Provider?
- 129. SAP Business One Adapter
- 129.1 How to create a business Object SAP BusinessPartner in SAP Business One?
- 129.2. How to Update a business Object SAP BusinessPartner in SAP Business One?
- 129.3. How to Delete a business object SAP Business Partner in SAP Business One?
- 129.4. How to Query a single, list, and Execute the SQL Query of business object in SAP Business One?
- 129.5 How to Create SQL Query in SAP Business One ?
- 129.6 How to use query parameter to get last data changed from SAP Business One?
- 130. Enable ODBC on the new Agent
- 131.How to use csv payload with ../V4/integrate?
- 132.How to logg the request and response for debugging purpose?
- 133.How to use the init-operation ‘Delete + Upsert’ to handle delta changes for parent-child interface?
- 134.How to transfer Salesforce business data to store in OneDrive.
- 135.How to use execute outbound interface group.
- 136.How to read data from OneDrive and push to Salesforce?
- 137.How to post complex objects with transactional support?
- 138.How to transfer Salesforce business data to store in Dropbox?
- 139.How to read data from Dropbox and push to Salesforce?
- 140.How to use the skyvva API to push data from Nav to Salesforce?
- 141.How to connect to Microsoft Dynamics NAV?
- 142. How to use v2 processing with New Agent?
- 143. How to save and read data from Google Drive?
- 144. How to use Flow to call our invokeCallOutV3() API?
- 145. How to use Process Builder to call our invokeCallOutV3() api?
- 146. How to call SKYVVA API from Stored Procedure in SQL Server
- 147. How to use Batch processing with new agent control board?
- 148. How to use Bulk processing with new agent control baord?
- 149. How to send only change field with Apex Trigger for Outbound Message?
- 150. Salesforce ID Handling Request and Response
- 151. How to use payload with /V4/IntegrateWithIMessage ?
- 152. How to use Amazon Control Board
- 153.How to use the API invokeCallout3() to pass data from the screen with Developer Console?
- 154. How to use Microsoft Dynamics 365 Adapter ?
- 155. How to use OData Adapter ?
- 156.What to do with failed messages when processing a new message with the same external Id?
- 157.What is Skyvva Bulk Data Loader?
- 158. How to use Microsoft One Drive Adapter
- 159. How to use INFOR ION Adapter?
- 160.How to Configure AWS S3 adapter?
- 161. How to use google cloud storage adapter?
- 162. How to import CSV using Agent File Adapter in Protocol: Local?
- 163. How to import XML using Agent File Adapter in Protocol: FTP?
- 164.How to use Amazon SQS adapter?
- 165. Search by the Business External Id in outbound message (Interface)
- 166.How to create Amazon S3 Adapter Outbound Processing with different payloads?
- 167. How to import JSON using Agent File Adapter in Protocol: SFTP?
- 168. How to export CSV using Agent File Adapter in Protocol: Local?
- 169. How to export Excel using Agent File Adapter in Protocol: FTP?
- 170. How to export XML using Agent File Adapter in Protocol: SFTP?
- 171.How to import binary file using Agent File Adapter?
- 172. Adapter Monitor on Agent Control Board
- 173. Log configuration on Agent Control Board
- 174. Scheduler on Agent Control Board
- 175. Log on Agent Control Board
- 176. How to create ngrok local server ?
- 177. How to Export the contentVersion with the agent as xml/Json and binary format?
- 178. Create only 1 API message that covers the request and response message