@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
@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…
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.