export Excel Sheet to Oracle database

[pszpadro]

Please provide information about the method - the software used - the source code in the case of exporting the excel sheet content to the prepared / created table on the database in Oracle. I am particularly interested in using this method in vba

[mlauber71]

@pszpadro welcome to the KNIME forum

@pszpadro

database in Oracle

There is an Oracle Connector – KNIME Community Hub to access a database.

Here are a few examples how you could work with KNIME and SQ/databases

KNIME and databases and SQL

[L4-BD] exercise 1 odyssey

@Thiemo.Kellner my suggestion would be to toy around with this workflow to see various functions and how they would work: [image] The ‘brown’ database connections are indeed a combination of SQL VIEWS that are put together without optimization (that would be the job of the database). I would assume this is because they are meant to function across a large number of databases and the combinations could be quite extensive (think: Hive, Impala, Big Data). So like with every database the user w…

Knime importing excel, exporting to postgresql

If you like SQL you could just use it. You could use H2 or SQLite as local databases which live in memory or on a single file on your hard drive. You could just load data there and do all the manipulation in SQL. You can just write the code ‘free’ or use the prepared nodes for databases that would translate into SQL - but if you are familiar with it you might not need it. Red DB connections would just transport the command to the database and you would have to do everything yourself (create …

H2 und SQL: https://kni.me/w/Ke-h87vETvtwqMaW

@pszpadro

using this method in vba

Not sure what you mean with that. Id od not think that KNIME and VBA would work closely together and a tool like KNIME should be able to substitute a lot of VBA functions.