Connecting with the SuiteCRM Connection Manager

Adding a new SuiteCRM connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the SuiteCRM Connection Manager from the Add SSIS Connection Manager window.

Alternatively, you can create a new connection directly using the SuiteCRM Source or the SuiteCRM Destination. You can set the connection properties in the SuiteCRM Connection Manager window.

Connecting To SuiteCRM V4.1 API

You can connect to SuiteCRM data via the V4.1 API by simply setting the following connection properties:

• Schema: Set this to suitecrmv4.
• Url: Set this to the URL associated with the SuiteCRM application, for example http://suite.crm.com.
• User: Set this to the user associated with the SuiteCRM account.
• Password: Set this to the password associated with the SuiteCRM account.

Connecting To SuiteCRM V8 API

Before Connecting

Before you connect to SuiteCRM V8 API you will need to first configure it in your SuiteCRM instance. The API can be configured in SuiteCRM version 7.10+. To configure the API, please follow the steps written in the SuiteCRM JSON API docs, found here: https://docs.suitecrm.com/developer/api/developer-setup-guide/json-api/#_before_you_start_calling_endpoints .

The SuiteCRM V8 API uses OAuth2.0 as its main method of authentication using 2 types of grant type, password or client credentials. Please see Using OAuth Authentication for a guide on how to connect with OAuth.