2020testuser opened a new issue #458:
URL: https://github.com/apache/camel-kamelets/issues/458
Hi,
Could anyone please help me?
I created the below Kameletbinding and it is not working.
I want to select all rows from Salesforce contact table and insert into
postgreSQL.
I have source as Salesforce and sink as postgreSQL.
1. Can I use postgreSQL as sink? Is it supported?
2. Is there any issue with the below kameletbinding? Do I need to do
anything additional? Thanks in advance!!
`
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: salesforce-source-binding-db
spec:
source:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: salesforce-source
properties:
clientId: "xxx"
clientSecret: "xxxx"
password: "xxxx"
query: "SELECT Id, Name, Email, Phone FROM Contact"
userName: "myname"
sink:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: sqlserver-sink
properties:
serverName: xxx
username: xxx
password: xxx
query: 'INSERT INTO contacts (name,email,phone) VALUES
(:#name,:#email,:#phone)'
port: 1433
databaseName: my_db
`
--
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]
