Connect to a database

Hi everyone,

Im trying to connect to (http://datasuite.company.io) of my company. But I don’t really know what should I do.

I appreciate any advise for me.

Hello @huynhduc,

you should share a bit more information like what kind of data(base) source are you trying to connect to? What nodes did you try? Does this base/source suggests how to extract data from it?

Br,
Ivan

2 Likes

Hi @ipazin ,

It’s me but in a different account :smiley: . Sorry for my unclear context. I am using DB Reader, to access to company’s DB. The purpose is I want to use prestoSQL which is the main type to extract data from my DB, connecting to DB Query.

But after opened the DB Reader and read some instructions, I didn’t find anything related to Datasuite. So that I’m quite confusing about it. I don’t know which info needed to process DB Reader

Most likely you will need to use a custom driver

https://prestodb.io/docs/current/installation/jdbc.html

The installation should then go along these lines. Though this is a different driver:

2 Likes

Hello @ducccccc,

for connecting to database you first need to establish connection using one of database connector nodes. For some databases KNIME has dedicated connectors (for example Microsoft SQL Server Connector node) and for others (like Presto if not mistaken) there is generic Database Connector node. After you establish connection you use DB nodes to filter/query you data and at the end comes DB Reader node.

In general I would advise you to take a look at KNIME DB guide to figure it out :wink:
https://docs.knime.com/latest/db_extension_guide/index.html#intro

Hope this helps!

Br,
Ivan

2 Likes