StreamSets

StreamSets

Connect with experts and peers to elevate technical expertise, solve problems and share insights.

 View Only

How do I configure a deployment so that all required drivers (JDBC) are baked in?

  • 1.  How do I configure a deployment so that all required drivers (JDBC) are baked in?

    Posted Fri January 14, 2022 06:26 PM

    You can do this in a couple of ways: users can upload JDBC drivers on their own when they're configuring a JDBC stage. This works well in a Dev environment where users need to have the flexibility to add external drivers to support new use cases. As an example see here: https://docs.streamsets.com/datacollector/UserGuide/Origins/MultiTableJDBCConsumer.html#concept_zsr_31x_4y

    In a Production environment, you really want to have a "locked down" configuration, so most likely you'll want to have all required drivers to be bundled in the configuration of your deployment; this can be achieved by uploading them in External Resources bundles; please see here for more detail: https://docs.streamsets.com/portal/#platform-controlhub/controlhub/UserGuide/Deployments/ExternalResource.html#concept_ixn_mjd_z4b