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:
– File Adapter ( CSV, Excel, XML)
– JDBC Adapter (ORACLE, SQLServer, MySQL, MsAcess)
– FTP/SFTP Adapter
– HTTP
– EMAIL
– SFDATALOADER
– SAP-R/3
– SFDC2SAPPI
– Data Loader
– REST
– Force2Force Adapter
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:
– File type: Choose CSV
– File Upload Mode: Choose CONTENT or FILE
– Folder: Choose the folder (path to get the file/ files)
– 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.
– After Processing: Choose what you want to do with your file
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.
– Backup Folder: The folder to keep the processed file. If you choose to backup
your file, you have to input your folder name here.
3. Click “Test Source Connection” to test the connection to the specified folder and
file.
4. 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:
– Database type: Choose SQLServer. The type of database to which the
adapter connects. Select between SQLServer or other.
– Username: sa
– Password: ******* (The default password to use when making the connection
to the database).
– Hostname: 192.168.1.141 (Ip address)
– Port: 1433 (default)
– Database Name:
– Server Instance: (Local)
3. Click “Test Source Connection” to test the connection to the specified folder and
file.
4. 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:
– Authentication: Username_Password
– URL: the URL to your FTP server – here we use http://www.bplaced.net/ but it
can be any link from your side
– Username: kktest (Username to log in to FTP server)
– Password: ******* (The default password to use when making the connection
to the FTP Server)
– FTP File Type: Choose CSV or other
– Folder: /KOLINA (path to get the file/ files)
– FTP Type: Choose FTP
– Port: 21(Default)
– File Name: (Optional) a filel name for agent to query data from
– After Processing: Choose what you want to do with your file
• 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.
– Backup Folder: The folder to keep the processed file. If you choose to backup
your file, you have to input your folder name here.
3. Click “Test Source Connection” to test the connection to the specified folder and
file.
4. 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:
- Log in to Salesforce and go to Setup then click on Custom Code.
- Click button “New Email service” –
->There are some field you must know on Email Service Information Page:
– Email Service Name: E.g. E-mail Adapter.
– Apex Class: search for “IAdapterEmailDataLoader”.
– Accept Attachments: All.
– Check icon ‘Active’.
– On Failure Response Setting: Click on Dropbox field and configure how Salesforce
response when an attempt to access this email service falls for the reason show
below.
– Click on “Save and New Email Address”.
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 –
- Add Email Address name-
- Email Address: –
->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:
– Click on the TAB “Adapter” than “New” and input the information in the require field:
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= ….)
– Attach the record that you want to import and send the email.
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).
– 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