SAP Cloud for Customer V2
SAP Cloud for Customer is a SaaS platform for sales and service enablement. You can use SAP Cloud for Customer as a data source when landing or replicating data.
SAP Cloud for Customer integration replicates data using the SAP Cloud for Customer OData API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
Pour plus d'informations, consultez Connexion à des applications SaaS.
- Complétez les propriétés de connexion requises.
Fournissez un nom pour la connexion dans Nom de la connexion.
Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.
Cliquez sur Créer.
| Setting | Description |
|---|---|
| Data gateway | Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données. |
| Username | Your user name in SAP Cloud for Customer. |
| Password | Your password in SAP Cloud for Customer. |
| OData URL | The OData discovery URL for your SAP Cloud for Customer tenant.
Examples:
Note InformationsChange data capture (CDC) is only supported when using the standard OData service URL ( c4codataapi). Custom OData service URLs expose different entities and do not support CDC. |
Schema
Schemas and naming conventions can change from version to version. Verify your version before continuing.
The schema information displayed below is for version 2.
The available datasets depend on your SAP Cloud for Customer source tenant configuration. Datasets are discovered dynamically using the https://<tenant>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi endpoint.
Depending on your destination, table and column names may not appear as they are outlined below.
ActivityCollection
The ActivityCollection table contains info about activities in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
ContractCollection
The ContractCollection table contains info about contracts in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
CorporateAccountCollection
The CorporateAccountCollection table contains info about corporate accounts in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
EMailCollection
The EMailCollection table contains info about email records in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
IndividualCustomerCollection
The IndividualCustomerCollection table contains info about individual customers in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
LeadCollection
The LeadCollection table contains info about sales leads in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
OpportunityCollection
The OpportunityCollection table contains info about sales opportunities in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
PhoneCallAttachmentFolder
The PhoneCallAttachmentFolder table contains info about attachments to phone call records in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
PhoneCallBTDReferenceCollection
The PhoneCallBTDReferenceCollection table contains info about business transaction document references for phone calls in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
PhoneCallPartiesCollection
The PhoneCallPartiesCollection table contains info about parties involved in phone calls in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
PhoneCallNotesCollection
The PhoneCallNotesCollection table contains info about notes attached to phone calls in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
PhoneCallParticipantsCollection
The PhoneCallParticipantsCollection table contains info about participants in phone calls in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |
TasksCollection
The TasksCollection table contains info about tasks in your SAP Cloud for Customer account.
| Replication Method | CDC |
| Primary Key | ObjectID |
| Replication Key | EntityLastChangedOn |
| Useful links | SAP Cloud for Customer OData API |