Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • MySQL Connector
NodeNode / Source

MySQL Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to a MySQL server via its JDBC driver. You need to provide the server's hostname (or IP address), the port, and a database name. Login credentials can either be provided directly in the configuration or via credential variables.

This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.

Node details

Output ports
  1. Type: DB Session
    DB Connection
    MySQL DB Connection.

Extension

The MySQL Connector node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    CREATE_PROCEDURE_MYSQL
    omprashad > Omprashad Khatri > CREATE_PROCEDURE_MYSQL_IN_KNIME > CREATE_PROCEDURE_MYSQL
    omprashad
  2. Go to item
    POSICAO CARTEIRA_2
    gabrieleneves86 > Public > POSICAO CARTEIRA_2
    gabrieleneves86
  3. Go to item
    SQL_conn + EDA
    bedy_kharisma > Public > SQL_conn + EDA
    bedy_kharisma
  4. Go to item
    2. Kafka Producer
    Kafka Data streaming
    Retrieve fraud data from database and stream it using kafka for model depployment
    hazirafidi > Public > ML Pipeline with Kafka Integration > 2. Kafka Producer
    hazirafidi
  5. Go to item
    demo_db_migration
    mraraman > Public > demo_db_migration
    mraraman
  6. Go to item
    Test_project
    gregstone > Public > Test_project
    gregstone
  7. Go to item
    demo_db_migration
    mraraman > VSR Workflows > adhocs > demo_db_migration
    mraraman
  8. Go to item
    Test_project
    walterthompson > Public > Test_project
    walterthompson
  9. Go to item
    Weather Update
    Takes in City + Country. Updates DB. Outputs Weather info.
    wkhan > Public > Weather DB Update
    wkhan
  10. Go to item
    Vendas Imputadas
    gabrieleneves86 > Public > Vendas Imputadas
    gabrieleneves86
  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits