To use JDBC to connect to a database, use the tELTInput component and enter the default table and schema names.
Join JDBC and other critical business data in Talend for a holistic view of your organization.
Whether you are on-prem, on-cloud, or somewhere in between, Talend can help you ETL, ELT, clean, govern, transform, and integrate your JDBC data.
Talend Data Fabric lets you integrate JDBC data and ensure that it — and all your company data — is clean, compliant, and broadly available. With integration tools Talend Studio and Talend Pipeline Designer, you can construct data pipelines using a drag-and-drop visual interface to extract data from JDBC plus hundreds of other data sources. You can run transformations in the pipeline using hundreds of bundled components. And you can replicate your data to virtually any destination, including cloud data warehouses such as Amazon Redshift, Google BigQuery, Snowflake, Microsoft Azure Synapse Analytics, and Delta Lake on Databricks; on-premises databases such as Oracle, Microsoft SQL Server, MySQL, and others via JDBC; and data warehouse appliances such as SAP HANA.
Talend Data Fabric is the only cloud-native tool that bundles data integration, data integrity, and data governance in a single integrated platform, so you can do more with your JDBC data and ensure its accuracy using applications that include:
Aggregate table columns and filter Use JDBC to gather data from several input DB table schemas and implement a clause to filter the output using an SQL statement See how >
ETL your JDBC data to the destination of your choice:
Deliver data your organization can trust. Get started today.