{"title":"DB Type Mapper","nodeType":"Manipulator","id":"*dX5ZVrdV7Jw2Sp0u","factoryName":"org.knime.database.node.datatype.mapping.DBTypeMappingNodeFactory","factoryId":"org.knime.database.node.datatype.mapping.DBTypeMappingNodeFactory","path":["DB","Utility"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Change the database to KNIME type mapping configuration for subsequent nodes based column name and database type or only database type. The dialog allows you to add new or change existing type mapping rules. It does not allow you to delete existing mapping rules. All rules from the input DB Data port that are not changed in the node dialog and forwarded unaltered to subsequent nodes e.g. if one of these mappings changes in a predecessor node these changes are propagated to all subsequent nodes of the DB Type Mapper node.</p>\n        ","shortDescription":"Enables you to change the database to KNIME type mapping for subsequent nodes.","keywords":["database","db","type","external","conversion","map","mapping"],"deprecated":false,"streamable":true,"tags":["DB","Utility","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAACfSURBVHgBrZLdDcIwDIRtlAHCBozAO0uxCUgswCaICViBDdpO0N5DIkXxxW3UnvQpf7ZjXSJygGYwgA94gIsTZ9A0KTWCMyswvW5m80QCo3SIFRilU9mDH3iCqxPHMIpVEpubdUw331Mn9a3NAuwVutQyURNZWozlmYYi6Q++4F0VVHEUSEB0kptGtkxcTQ6y08RA9ryfaLrYYmIWNXMBkFEzBE4VzXgAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data with the input database to KNIME type mapping configuration."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"Data object with the changed database to KNIME type mapping configuration."}],"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":"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":"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}]}],"links":[],"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":[{"id":"*mgAu4IAMHNlmybx4","factoryName":"org.knime.database.node.manipulation.query.DBSQLQueryNodeFactory","probability":1.0}]}