Connector guide

1.1.Salesforce

To create your Salesforce connector, you will need :

  • Your username
  • Your password
  • Your token
  • Your Consumer key
  • You consumer secret
  • Indicate if you are connecting a sandbo

 

01_fields

How to get you security token ?

  1.  Connect to Salesforce with your login and password.
  2. From the homepage of your account, click on your username then on “My Settings”.
  3. Then choose “Personal”
  4. And click on “Reset my secuity token” (It will be sent by email)

02_token

Consumer Key and Consumer Secret

You need to create an app.

From Setup, enter Apps in the Quick Find box, then select Apps. Then select Create, then Apps.

03_create_app

Then create a connected app by clicking on “New”

04_create_app

After typing your App Name, API name and email address, enable OAuth Settings

Put your Salesforce URL and choose Full access. Save.

 You will be redirected to the presentation page of your app. There you’ll find your Consumer Key and Consumer Secret.

06_keys

Fill the connector creation form in Myddleware :

07_end

Congratulations! You have created your Salesforce connector, now you can sync your data from and to your Salesforce!

1.2.SuiteCRM

SuiteCRM : all versions.

To connect SuiteCRM to Myddleware, you need your user name, your password and your URL:

connect

Tip: Use the username and password of a user having the rights to make the rules, write access, read, edit …

connector-suitecrm

Congratulations, you‘ve created your SuiteCRM connector! You can now use it to synchronise to or from this solution.

1.3.SugarCRM

SugarCRM from version 6.5

Myddleware is compatible with SugarCRM CE and SugarCRM PRO v6.2 and upper

To connect SugarCRM to Myddleware:
You need your username, your password and your Url

connect

However there is a subtlety about your URL, simply add the following :  service/v4/rest.php

With the example above it will be “your-crm.fr/sugarcrm/service/v4/rest.php

Tip: Use the username and password of a user having the rights to make the rules, write access, read, edit …

connector-sugarcrm

Congratulations, you‘ve created your SugarCRM connector! You can now use it to synchronise to or from this solution.

1.4.SageCRM

To create Sagecrm connector, you will need:

– Your user email address.

– Your password.

– A WSDL file you have to download.

01_champs_connecteur

The user and the password are those you use to access you Sagecrm account.

To download the WSDL file, you must connect to your Sagecrm account and click on Administration.

02_administration

Once you’re in “Manage My Account”, click on “External Access” and then on “View Web Services WSDL”.

03_externe

A new page open. You have to save it.

04_enregistrer

Now, go to your Myddleware environment where you create a new connector. After typing the email address and the password click on “wsdl file”. Chose the file you just downloaded and then transfer it.

05_transfert

The file has been transfered successfully.

06_transfert_ok

Test your connection. If the bulb is green then it’s working!

07_connecteur_ok

Chose a name for your connector and save it.

Congrats! You created your Sagecrm connector! You can now use it to synch data form this solution.

1.5.SAP CRM

The SAP CRM connector can only be set up by our team.

To know more about this connector, please fill the contact ‘s form here.

2.1.Prestashop

Prestashop 1.5 and 1.6
This tutorial will allow you to realize the PrestaShop connector.

To do this, you will need the URL of your shop and an API key that you generate yourself.
How to generate this key?
To generate this key you should go in the back office of your shop.Go to Advanced Settings” and then “Webservice

tableau-de-bord

Then “enable webservice” (save if the webservice was not activated) then click “Add new webservice key” (black arrow)

webservice

Finally “Generate” key, set the “Status” to Yes, and select the check boxes View, Edit, Add
and Fast view (as in the example where all boxes below will be checked).

cle-service-web

Finally back up and recover your API key to create your connector.

connecteur-prestashop

Congratulations, you’ve created your PrestaShop connector! You can now use it to synchronise to or from this solution.

2.2.Magento

Magento version 2.

To connect SuiteCRM to Myddleware, you need your user name, your password and your URL:

magento_login

Use the username and password of a user having the rights you need in Myddleware. Add the URL of your boutique as well.

magento_connector

Congratulations, you‘ve created your Magento connector! You can now use it to synchronise to or from this solution.

2.3.Shop Application

To connect Shop application to Myddleware, you need these parameters :

  • URL of your shop application
  • API key. Ask shop application team to give it to you.

Then save you connector.

3.E-Marketing platform

3.1.Mailchimp

This tutorial will help you in creating your Mailchimp’s connector.

For that you will need to create an application in your mailchimp account to generate an ID client and an Secret client.

Connect to Mailchimp

login_mailchimp

Open your profile:

mailchimp_profile

Then go on  Extra -> Registered Apps and click on “Register an App” :

mailchimp_register_app

Fill the form to create your app :

mailchimp_create_app

Make sure that the callback URL is correct. For example, if the URL of your Myddleware is http://mydomaine/web/app.php then your callback URL is http://mydomaine/web/app.php/callback/

Then click on “Create” and get the client ID and the client secret :

mailchimp_get_id

Now, you can create your connector in Myddleware. Use the same callback URL, the client ID and client secret to create this connector :

mailchimp_create_connector

Click on “test”, a popup opens, Use your Mailchimp account and click on “Log in”:

mailchimp_popup

If the popup doesn’t open, Check that your browser isn’t blocking it. For example in Firefox you will have this :

mailchimp_popup_block

The the popup is closed. Click on “OK” on the Myddleware popup to validate the connection :

mailchimp_reconnect

Add a name for your connector and click on “save” :

mailchimp_create_connector

Congratulations, you have successfully created your Mailchimp connector.

3.2.Dolist

In this tutorial, we‘ll learn how to create a Dolist connector.

For this purpose, we will proceed in stages:
Connecting to your environment Dolist
Creating an authentication Dolist
Retrieving information needed to create the connector in Myddleware.

 

1st step: Connect to your Dolist environment:

Go to your Dolist login portal and enter your logins.

Once connected, you will be redirected to the home page. Click on the administration tab as show in the picture:

dolist-ongletadmin

The administration tab is now open , you will find in the left menu a subsection named Web Services”, click on it.
The different following tabs should appear, the one which interests us is key management”.

manage-keys

You are now ready to move to the second step.

2nd step: Creating a Dolist authentication

 

When you’re on the “manage keys” tab, click on “Add a new Authentication”:

authentification

The form below appears:

form

You now must fill the necessary fields, we advise you not to choose the restriction by IP and to check the “permanent validity”. If however you wish to add Myddleware IP to your restrictions, please contact us.

Congratulations, you just created your Dolist authentication for Myddleware!

3rd Step: Retrieving necessary informations

For this last step, just click on button “See Key” or “See the authentication keyif you are still on the plug of your authentication.

see-key

see-key-2Enter your logins to display the following information:

info

Take note of your Account ID and your authentication key so that you can fill the fields when creating your Dolist connector on Myddleware.

dolist-connecteur

Congratulations, you‘ve created your Dolist connector! You can now use it to synchronise to or from this solution.

4.1.Microsoft SQL

To connect a Microsoft SQL database to Myddleware, you need these parameters :

  • User
  • Password
  • Host server
  • Database name
  • Database port access

Complete all these information to connect your Microsoft SQL database and test the connection. Then save you connector.

You have to to enable the php module PDO. This page should help you : http://php.net/manual/en/pdo.installation.php

Myddleware use the PDO driver dblib.

4.2.MySQL

To connect a MySQL database to Myddleware, you need these parameters :

  • User
  • Password
  • Host server
  • Database name
  • Database port access

Complete all these information to connect your MySQL database and test the connection. Then save you connector.

Myddleware use the PDO driver mysql.

You have to to enable the php module PDO. This page should help you : http://php.net/manual/en/pdo.installation.php

5.1.Sage Live

To create your Sage Live connector, you will need :

  • Your username
  • Your password
  • Your Consumer key
  • You consumer secret
  • Indicate if you are connecting a sandbox

Consumer Key and Consumer Secret

You need to create an app.

From Setup, enter Apps in the Quick Find box, then select Apps. Then select Create, then Apps.

03_create_app

Then create a connected app by clicking on “New”

04_create_app

After typing your App Name, API name and email address, enable OAuth Settings

Put your Sage Live URL and choose Full access. Save.

 You will be redirected to the presentation page of your app. There you’ll find your Consumer Key and Consumer Secret.

06_keys

Fill the connector creation form in Myddleware :

Congratulations! You have created your Sage Live connector, now you can sync your data from and to your Sage Live!

5.2.Bittle

In this tutorial we will list the elements that may be required to create the connector. We will moreover, show you how to get them.

Below is the list:

connector_creation

To get the User IDand the Company ID token, contact Bittle either by email at: contact@bittle-solutions.com or by telephone: +33 (0) 4 42 12 54 57

 

You also have to get the Url that allows you to connect to Bittle.

bittle_url

With these elements you can create your connector.

myddleware_connector

Congratulations, you have successfully created your Bittle connector ! You can now synchronise this solution.

5.3.Moodle

Moodle version 3.

Generate your token by followingthis tutorial : https://docs.moodle.org/20/en/Using_web_services

Myddleware use the protocol REST.

Then open your external service :

moodle_external_service

Make sure you have add these functions in your external services :

In red the standard function required to use Myddleware.

In blue the custom functions used by Myddleware to read the user completion and their last access to a course. These functions are optional. But if you want to use them you have to download and install the plugin Myddleware from the plugin Moodle website.

Then add the URL of your Moodle instance and your token in Myddleware :

moodle_connector

Congratulations, you‘ve created your Moodle connector! You can now use it to synchronise to this solution.

5.4.Eventbrite

In this tutorial we will see how to create the Eventbrite Connector.
To do this, you will need your security token and that’s it.
However we need to create an application.

First, log on to your Eventbrite environment.

account

Then go to “Account settings”

account

Then at the bottom left, click on “App Management

management

Create a new app.

new-app

There, you enter the data that is requested, and then click Create Key

create-key

Then you automatically return to “App Management” and you can get your token.

Please note that you must select this one: “Your personal OAuth token”

view

You can now create your connector.

connector-eventbrite

 Congratulations, you‘ve created your Eventbrite Connector! You can now use it to synchronise to or from this solution.

5.5.File (FTP)

To connect Myddleware to a ftp server, you need these parameters :

  • User
  • Password
  • Host server
  • Port
  • Directory where the file will be stored (eg : /home/myddleware/my_diretory)

file_connector

Complete all these information to connect your ftp server and test the connection. Then save you connector.

Myddleware use the php function ssh2_connect and ssh2_auth_password to connect to your ftp server, click on it to have more information.

Suggest Edit