Talend Cloud Data Connectors

 

List of supported Talend Cloud Data Connectors

List of the environments and systems to which you can connect.

Unless stated otherwise the latest versions are supported.

Supported connectors and their categories
Supported system	Connection type	Unidirectional / Bidirectional
Amazon Aurora	Databases	Bidirectional
Amazon DynamoDB	Databases	Bidirectional
Amazon Redshift	Databases	Bidirectional
Apache Kudu	Databases	Bidirectional
Azure Cosmos DB	Databases	Bidirectional
Azure Synapse	Databases	Bidirectional
Couchbase	Databases	Bidirectional
Delta Lake	Databases	Bidirectional
Derby	Databases	Bidirectional
Google BigQuery	Databases	Bidirectional
Google Bigtable	Databases	Bidirectional
MariaDB	Databases	Bidirectional
Microsoft SQL Server	Databases	Bidirectional
Microsoft SQL Server - JTDS driver (Deprecated)	Databases	Bidirectional
MongoDB	Databases	Bidirectional
MySQL	Databases	Bidirectional
Oracle	Databases	Bidirectional
PostgreSQL	Databases	Bidirectional
SingleStore	Databases	Bidirectional
Snowflake, including pushdown capabilities	Databases	Bidirectional
Amazon S3	Cloud file systems	Bidirectional
Azure Blob Storage	Cloud file systems	Bidirectional
Azure Data Lake Storage Gen2	Cloud file systems	Bidirectional
Box	Cloud file systems	Bidirectional
Google Cloud Storage	Cloud file systems	Bidirectional
Dynamics 365	Business applications	Bidirectional
Marketo	Business applications	Bidirectional
Google Analytics	Business applications	Input only
Google Analytics 4	Business applications	Input only
NetSuite	Business applications	Bidirectional
Salesforce	Business applications	Bidirectional
Workday	Business applications	Bidirectional
Zendesk	Business applications	Bidirectional
HTTP Client	Web services	Bidirectional
REST (deprecated)	Web services	Bidirectional
FTP	File systems	Bidirectional
HDFS	File systems	Bidirectional
Amazon Kinesis	Messaging	Input only
Apache Pulsar	Messaging	Bidirectional
Azure Event Hubs	Messaging	Bidirectional
Google PubSub	Messaging	Bidirectional
Kafka	Messaging	Bidirectional
RabbitMQ	Messaging	Bidirectional
ElasticSearch v2.4.4 to 6.3.2	Search and index	Bidirectional
Local connection: This built-in connection allows you to store your local file as a dataset.	Local connection (for local data)	Bidirectional
Data generator: This connection allows you to generate random realistic data according to the conditions you define.	Test connection (for test data)	Input only
Test connection: This built-in connection allows you to enter manually your test data as a dataset.	Test connection (for test data)	Bidirectional
Talend Cloud Data Stewardship campaigns can be retrieved and used as pipeline sources and destinations, allowing you to both read from them and write into them.	Talend Cloud platform	Bidirectional

 

python

 import datetime

import pandas as pd
import cx_Oracle
con = cx_Oracle.connect('SYSTEM/oracle123@localhost:1521/xe')
c = con.cursor()
sql = "select * from covid_data"
res = c.execute(sql)
t = pd.read_sql(sql,con)
t.to_csv(r'C:\Users\abc\covid.csv')

#t.to_csv(r'C:\Users\abc\covid.csv', mode='w')