I am trying to import data from an Excel file and then exporting it to and MS SQL Db, and create a table on the go during the export.
I am having trouble finding how to export to mssql. Im new to Knime. Coming from Alteryx.
Thank You,
Shounak…
I am trying to import data from an Excel file and then exporting it to and MS SQL Db, and create a table on the go during the export.
I am having trouble finding how to export to mssql. Im new to Knime. Coming from Alteryx.
Thank You,
Shounak…
Hi there @thunderbolt983,
welcome to KNIME!
For exporting data to MS SQL DB and creating table during the process you can use DB Writer node. On this link you can find and download workflow examples where this node was used. For example here is a simple one. In general for database operations one should use nodes from KNIME Database Integration.
For a bit more information regarding Alteryx check this topic:
Br,
Ivan
Got the solution. Thank you for your reply. although found another way.
Took some time to figure that out, ofcourse got expert help in it.
Keep Calm and Analyse Data
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.