{"title":"DB Connector","nodeType":"Source","id":"*xdTzh7uothbq7MV5","factoryName":"org.knime.database.node.connector.generic.DBConnectorNodeFactory2","factoryId":"org.knime.database.node.connector.generic.DBConnectorNodeFactory2","path":["DB","Connection"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node creates a connection to an arbitrary JDBC database. You need to select an appropriate driver and provide the JDBC URL of the database (which is database specific). New database drivers are registered via the KNIME preferences page. Login credentials can either be provided directly in the configuration or via credential variables.</p>\n        ","shortDescription":"Create a database connection to any JDBC database.","keywords":["database","db","connection","session","create"],"deprecated":false,"streamable":true,"tags":["DB","Connection","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RDQ0MjFGMTQ4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDQ0MjFGMTM4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpFMUNDOEYxQjgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpFMUNDOEYxQzgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pt130dEAAADVSURBVHjaYmRgYLgNxJeBeC8Qr/z///8bBhLBfyT8DYgTgIYwEIsZoRqRwVegBA+xtjNhEesm1Qu/gfgcEPcBsS4pzod5gQnI+MdAJkDRzMjIqArEraQakg7EU4H4Giw28DkZquYdEh8lGkH4LSkGoMcCKDHZkuJ8FiBuAeIrQHwMaOJjkkMRixP10PhnkMMF3QsswFAXAGkCYmcg9gNiA1CEINmxB4iNgeqQU+xZXHkBhP9icdVuJPndaHIomr8DcSGpKfEmNBCPA/EyoOAzUsIQIMAA93kcVQ+qen4AAAAASUVORK5CYII=","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"DB Connection to the database."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Database type","description":"This option allows you to explicitly define the type of database the node connects to. Depending on the database type the SQL dialect, the supported data types and statement such as insert, update, delete or drop as well as the aggregation functions might differ.","optional":false},{"name":"Database dialect","description":"Choose the registered database dialect here.","optional":false},{"name":"Database URL","description":"Enter the database name here, for example jdbc:mysql://host:port/database_name","optional":false},{"name":"Use latest driver version available","description":"If selected, upon execution the node will automatically use the driver with the latest (highest) driver version that is available for the current database type. This has the advantage that you do not need to touch the workflow after a driver update. However, the workflow might break in the rare case that the behavior of the driver e.g. type mapping changes with the newer version.","optional":false},{"name":"Database driver","description":"Choose the JDBC driver to connect to the database here. You can select a specific version of the registered drivers via the drop-down list. Additional drivers can be registered via KNIME&#39;s preference page &#34;KNIME -&gt; Databases&#34;.","optional":false},{"name":"Authentication type","description":"The type of the used authentication.\n<ul><li><b>None</b> : No authentication is required.</li><li><b>Username</b> : Username-based authentication. No password required.</li><li><b>Username and Password</b> : Username and password based authentication.</li><li><b>Password</b> : Password based authentication. No username required.</li><li><b>Kerberos</b> : Kerberos ticket based authentication</li></ul>","optional":false},{"name":"Credentials","description":"The credentials used for the authentication.","optional":false},{"name":"JDBC parameters","description":"This tab allows you to define JDBC driver connection parameter. The value of a parameter can be a constant, credential user, credential password or KNIME URL. For more information about the supported driver properties see the documentation of the selected database.","optional":false},{"name":"Input mapping by name","description":"Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.\n<ul><li><b>Column selection type</b> : The option allows you to select how the column is matched.\n  <ul><li><b>Manual</b> : Use the exact name of the column</li><li><b>Regex</b> : Allow regex expressions to select multiple columns</li></ul></li><li><b>Column name</b> : The name or regex expression.</li><li><b>Database type</b> : SQL type to map from.</li><li><b>Mapping to</b> : Datatype to map to.</li></ul>","optional":false},{"name":"Input mapping by type","description":"Columns that match the given database type will be mapped to the specified KNIME type.\n<ul><li><b>From type</b> : SQL type to map from.</li><li><b>To type</b> : Datatype to map to.</li></ul>","optional":false},{"name":"Output mapping by name","description":"Columns that match the given name (or regular expression) and KNIME type will be mapped to the specified database type.\n<ul><li><b>Column selection type</b> : The option allows you to select how the column is matched.\n  <ul><li><b>Manual</b> : Use the exact name of the column</li><li><b>Regex</b> : Allow regex expressions to select multiple columns</li></ul></li><li><b>Column name</b> : The name or regex expression.</li><li><b>Source type</b> : Datatype to map from.</li><li><b>Mapping to</b> : SQL type to map to.</li></ul>","optional":false},{"name":"Output mapping by type","description":"Columns that match the given KNIME type will be mapped to the specified database type.\n<ul><li><b>From type</b> : Datatype to map from.</li><li><b>To type</b> : SQL type to map to.</li></ul>","optional":false},{"name":"Additional settings","description":"This tab allows you to define KNIME framework properties such as connection handling, advanced SQL dialect settings or logging options. The available properties depend on the selected database type and driver. For more information about the supported parameters see the <a href=\"https://docs.knime.com/latest/db_extension_guide/index.html#advanced-tab\" rel=\"ugc nofollow noopener noreferrer\">KNIME Database Extension Guide.</a>","optional":false}]}],"links":[{"text":"Database documentation","url":"https://docs.knime.com/ap/latest/db_extension_guide/#connecting-to-a-database"}],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}