SK SKYVVA Documentation

27. Overview of existing Skyvva adapters

1 What is Adapter? An adapter is a device for connecting pieces of equipment that cannot connected directly. Adapter is also important; without it, you cannot transfer the data to the external system. It provides the interface between a computer and a network connection. There are many different types of adapters such as File Adapter, Database Adapter, FTP/SFTP Adapter, SAP-R/3 Adapter and SAP-ERP Adapter. File Adapter and Database Adapter supported for Agent. However, SAP-R/3 and SAP-ERP Adapter are used to connect to SAP-R/3. 2 Type of Adapter This section will be describe about adapter types of SKYVVA. We have three types of adapters:

2.1 File Adapter File adapter use to integrate data from file to SFDC and from Salesforce to file. The filetype that our Agent support is CSV, XML and Excel that can be integrated with their content. You can integrate file attachment into attachment object. This document is focus only on the creation of adapter, so some steps before it would be skip eg. Creating Integration and Interface. To create File Adapter, there are some steps must be followed: Run Agent UI > Integration Wizard > Choose Integration > Choose existing interface.
  1. Adapter Section: Choose Adapter Type (File) > Name Adapter
  2. Adapter Properties:
  3. File type: Choose CSV
  4. File Upload Mode: Choose CONTENT or FILE
  5. Folder: Choose the folder (path to get the file/ files)
  6. File Name: Choose file name (a file name for agent to query data from. If this
field is empty, it mean you to select all files in the selected folder.  Keep File: The file will keep in the folder.  Lock File: The file will lock.  Delete File: The file will delete.  Backup File: The file will backup in the other folder. your file, you have to input your folder name here.
  1. Click “Test Source Connection” to test the connection to the specified folder and
file.
  1. Click Save.

Note: For Excel and XML File, you can just do the same as CSV File. But you only need to change the file types, adapter and its properties accordingly. 2.2 JDBC Adapter JDBC Adapter is used as a connector to transfer data from Database to Salesforce and from Salesforce to Database. Agent supports five database type include Oracle, SQLServer, MySQL, MsAcess and PostgreSQL. The following sample is about SQLServer onfiguration. Run Agent UI > Integration Wizard > Choose Integration > Choose existing interface.

  1. Adapter Section: Choose Adapter Type (JDBC) > Name Adapter
  2. Adapter Properties:
  3. Database type: Choose SQLServer. The type of database to which the
adapter connects. Select between SQLServer or other. to the database). file.
  1. Click Save

Note: For Oracle, MySQL, MsAcess and PostgreSQL database, you can just do the same as SQLServer. But just you need to change the database types, adapter and its properties accordingly. 2.3 FTP/SFTP Adapter FTP Adapter is used as a connector to transfer data from FTP server to Salesforce and from Salesforce to FTP server.To create FTP Adapter, there are some steps must be followed: Run Agent UI > Integration Wizard > Choose Integration > Choose existing interface.

  1. Adapter Section: Choose Adapter Type (FTP) > Name Adapter
  2. Adapter Properties:
  3. Authentication: Username_Password
  4. URL: the URL to your FTP server – here we use http://www.bplaced.net/ but it
can be any link from your side to the FTP Server) • Keep File: The file will keep in the folder. • Lock File: The file will lock. • Delete File: The file will delete. • Backup File: The file will backup in the other folder. your file, you have to input your folder name here.
  1. Click “Test Source Connection” to test the connection to the specified folder and
file.
  1. Click Save.

Note: For SFTP configuration, please kindly look for document 2.5 Email Adapter Email adapter is support-sending email to Salesforce using an attachment (source file) to carry the business data. The functionality is to pass parameters to the email subject and body. You can pass business data with the subject and body. As soon as the Email arrives, the data import is initiated automatically. -> The configuring of email service on Salesforce This section will be explained the process of configuring the Email-Service on Salesforce.You can follow the steps         below:

->There are some field you must know on Email Service Information Page:

response when an attempt to access this email service falls for the reason show below.

Note: If you did not Check icon 'Active'  the Email Service is created deactivated in this case you can of the active manually , You will see under Setup -> App Setup -> Custom Code-> Email Service -> Click on your Email Service Name -

->Creating an Email adapter For this part, the explanation will be focus on the creating of email adapter. To create adapter you can follow the         steps below:

 Name: E.g. E-Mail Adapter  Type: Select from the Dropbox=> Email => Click Save

->Editing on Interface You can enter your existing interface and do some editing by choosing adapter. E.g. Email Adapter.

Subject Line of your Email Accept the email address from salesforce.com by email. The subject line of the email should read as follows: integration=your_IntegrationID;interface=Name_of_the_Interface Note: Provide the IntegrationID and the name of the Interfaces. The IntegrationID is found in the URL of the actual Integration. When you are there, search for a 15-digit ID(id= ....)

  1. E-mail address generated by Salesforce .
  2. Integration=your_IntegrationID;interface=Name_of_the_Interface.
  3. Record that you want to import (must be the same in structure implements our interface).
  4. In addition, send the email.
TIP: Be sure to test the mapping of your integration first (manual upload). If this works, then get to work with the mail import

Open this article in the interactive viewer →