Connecting to PostgreSQL
To get started, first decide what data in Postgres you want to work with, then log in to Talend Data Fabric and choose a Talend app from the drop-down list. Use the tPostgreSQLConnection component. Enter your username, password, and a JDBC URL that identifies your Postgres database.
Learn more about connecting to PostgeSQL
More info on JDBC URLs
More about integrating PostgreSQL data
Talend has detailed documentation
on how to ETL your PostgreSQL data for a better view of the business.
Connecting to SQL Server
SQL Server is a popular relational database management system created by Microsoft.
Connect to your Microsoft SQL Server database with our native connector and easily carry out the following actions on your data:
- Write, update, make changes or suppress entries defined on a table and/or on the data contained in a table
- Prepare a file to be used as parameter in an INSERT query to feed a MS SQL database.
- Execute a SQL query stated onto a specified Microsoft SQL Server or Azure SQL database.
- Offer a convenient way to centralize multiple or complex queries in a database and calls them easily.