2. Configuring the Layer2 Cloud Connector
2.1. Creating a new connection
We are going so synchronize our Authorize.NET to a custom SharePoint list. This is a uni-directional (Left to right) only connection.
Create a new connection in the Layer2 Cloud Connector, name it and set the direction to Left to Right.
2.2. Configuring the start system
Select the provider for Authorize.NET.
Select the source system and name it.
Set the connection string with the parameters from your Authorize.NET account.
And your admin password. If you are in the live environment, you do not need the UseSandbox parameter.
The Select statement:
SELECT * FROM CustomerProfileDetails WHERE CustomerProfileId=the_profile_id;
Set your primary key too.
If everything runs fine, you will be prompted to login and your data will be visible after.
2.3. Configuring the end system
We are going to send the data to a custom SharePoint list. First create your list with the desired columns and then copy the URL.
For more information about the SharePoint provider visit:
Enter your password in the dedicated field and a primary key.
If the fields from SharePoint are named identical to the fields from the source system, the auto-mapping function will work fine. We mapped our fields manually in this case.
2.4. Running your connection
You can now run your connection.
Data overview on the Authorize.NET entity.
And the transferred data to our custom SharePoint list.