SugarCRM
SugarCRM is a cloud-based application for handling sales automation, marketing automation, account management and customer relationship management. You can land data fromSugarCRM as a data source when landing or replicating data.
-
For more information about connecting to SaaS applications, see 連線到 SaaS 應用程式.
-
資料閘道 - 資料移動 must be installed to land or replicate data from SaaS applications. For more information, see Qlik 資料閘道 - 資料移動.
Supported update methods
For more information, see 變更處理.
Landing tasks:
-
Change data capture (CDC)
-
Reload and compare
Replication tasks:
-
Change data capture (CDC) using Change Tables
-
Full load
Landing data in a data lake tasks:
-
Change data capture (CDC)
-
Reload
Preparing for authentication
To access your SugarCRM data, you need to authenticate the connection with your account credentials.
For more information about retrieving your authentication settings, see REST API.
Creating the connection
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
| Setting | Description |
|---|---|
| Gateway |
Select a 資料移動閘道 to use when replicating data. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
| Username | User name. |
| Password | Password to the account. |
| Platform | Platform. |
| Version | Version. |
| Site URL | Site URL |