2020testuser commented on issue #458:
URL: https://github.com/apache/camel-kamelets/issues/458#issuecomment-901381772


   @oscerd - Hope you are back from your PTO. Could you please let me know 
where the setup/configuration for salesforce polling is? 
   Also, for salesforce as source and postgresql as sink, I performed the below 
steps. Could you please check and let me know if I'm missing anything as still 
I'm unable to get it working? It would be great if you could provide some 
details on this. Thanks in advance!
   
   1. Installed kamel in my namespace
   2. Deployed the Salesforce source yaml (copied the yaml from the below link 
and deployed 'as is') using Kubectl apply command
   
`https://github.com/apache/camel-kamelets/blob/main/salesforce-source.kamelet.yaml`
   3.  Deployed the Salesforce source yaml (copied the yaml from the below link 
and deployed 'as is') using Kubectl apply command
   
`https://github.com/apache/camel-kamelets/blob/main/postgresql-sink.kamelet.yaml`
   4. Deployed the kamelet that I created . yaml below.
   `
   apiVersion: camel.apache.org/v1alpha1
   kind: KameletBinding
   metadata:
     name: salesforce-source-binding-db
   spec:
     integration:
       dependencies: 
           - "camel:jackson"
           - "camel:kamelet"
           - "camel:sql"
           - "mvn:org.postgresql:postgresql:42.2.14"
           - "mvn:org.apache.commons:commons-dbcp2:2.8.0"
     source:
       ref:
         kind: Kamelet
         apiVersion: camel.apache.org/v1alpha1
         name: salesforce-source
       properties:
         clientId: "xxx"
         password: "xxx"
         query: "SELECT Id, Name, Email, Phone FROM Contact"
         userName: "[email protected]"
     sink:
       ref:
         kind: Kamelet
         apiVersion: camel.apache.org/v1alpha1
         name: postgresql-sink
       properties:
         serverName: myhost
         username: xxx
         password: xxx
         query: 'INSERT INTO contacts (name,email,phone) VALUES 
(:#name,:#email,:#phone)'
         port: 1433
         databaseName: mydb
   
   `
   5. Logged into Salesforce developer site with my free account. Created a 
contact.
   6. Checked in postgresql and didn't find any new row created under contacts 
table.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to