{"title":"Extract Variables (Database)","nodeType":"Other","id":"*L_NCl_TkcRZWlolR","factoryName":"org.knime.base.node.flowvariable.extractvariables.ExtractVariablesDBNodeFactory","factoryId":"org.knime.base.node.flowvariable.extractvariables.ExtractVariablesDBNodeFactory","path":["Workflow Control","Variables"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node extracts variables from a given database connection</p>\n        ","shortDescription":"Extracts Variables from a Database connection.","keywords":[],"deprecated":false,"streamable":false,"tags":["Workflow Control","Variables"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6QkYyNjg3MDY3RjFEMTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6QkYyNjg3MDU3RjFEMTFFNUE3NjBCMzY2NkE3NjU5N0EiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoyNjE5N0RCODQ1QzcxMUU1QUM2QkE3NzQyQjhFM0EyRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoyQjA3NUZBMjQ1QzcxMUU1QUM2QkE3NzQyQjhFM0EyRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PgJXPbIAAAFGSURBVHjapJI9L0RBFIZnNldCoZBoVqLTaDY+4h9Q+kjEqigUQiEKepR0WxJR6GQLH71WolCgEpEQhYRY0a1sYjxnc4bJNVdu4k2ee2bOPXPuzHvHusvkxRgjXMMpHJhS492orLV3hDbo0lQH1KDqnCsXGHRCL5RhGx7NVcuk+dEOFGFQ51Maq/IomN9qh71UA9FwEOt/NRBdBOM3LV7W+ShU/Mt0g1fYgrFU3h9jHlr915seYeIq8VlNFIZgFiMX1URfW9NY94ZiYnMHN+rsCjzAGSxEjrWpdZUwKTtwURdKDWtyKMvEE5NTYYNPOIc5mA6LnsYn1sFlNRiBgcCHfrgPFxPWsnYgHuwTe6BPr+y3B1lfDZXATCT/kdeDJJKT/7wkg+LxkQ2PIPOYB3JBbuFQPehm+7u+gEXSYCPbA+fMf/QlwADk0VfNMmEJEQAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.port.database.DatabasePortObject","color":"800000","dataType":"Database Query","optional":false,"name":"Database connection","description":"Port object holding database connection (and variables)."}],"outPorts":[{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":false,"name":"Variable port","description":"The variable values."}],"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":[],"links":[{"text":"KNIME Documentation: Creation and usage of flow variables in a KNIME workflow","url":"https://docs.knime.com/ap/latest/analytics_platform_flow_control_guide/#flow-variables"}],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*uLyMaZRk4kf96S85","factoryName":"org.knime.base.node.meta.looper.recursive.RecursiveLoopEndNodeFactory","probability":0.2},{"id":"*8Mn_4LtrzrbzyAti","factoryName":"org.knime.base.node.io.filereader.FileReaderNodeFactory","probability":0.1},{"id":"*czF_b1jv4IgZUqyZ","factoryName":"org.knime.base.node.jsnippet.JavaEditVarNodeFactory","probability":0.1},{"id":"*fK0j1K1mcusekRy2","factoryName":"org.knime.base.node.io.database.DBReaderNodeFactory","probability":0.1},{"id":"*-PBwCzm6eyeiZ2nd","factoryName":"org.knime.ext.jep.variable.JEPVariableNodeFactory","probability":0.1},{"id":"*UL6NmjxIO-RtvsCX","factoryName":"org.knime.base.node.io.database.connection.DBTableSelectorNodeFactory","probability":0.1},{"id":"*Y_8cAJatl5UQNkJy","factoryName":"org.knime.base.node.flowvariable.variabletotablerow2.VariableToTable2NodeFactory","probability":0.1},{"id":"*6qPKqqqXXYoDtRvO","factoryName":"org.knime.base.node.flowcontrol.trycatch.genericcatch.VariablePortCatchNodeFactory","probability":0.1},{"id":"*ZGTqWYyk_JhsxQTj","factoryName":"org.knime.ext.poi.node.write2.XLSWriter2NodeFactory","probability":0.1}]}