I have just installed QLik Sense and want to connect to an Interbase server

[#1]

I want to connect to data in our Interbase sql server. I see a list of database servers but no Interbase is available.

I know that ODBC is a work around.

Anyone who connect with Qlik to an Interbase SQL server?

[thkarner]

Hi,

as I know there is now specific Interbase SQL Server connector available.

You can connect via ODBC or OLEDB. The appropriate component from Interbase have to be installed beforehand.

Regards,

Thomas

PS: Please mark this as helpful or correct if applicable

[#3]

Hi,

Thank you. Do you know if there are plans?

Kind Regards,

André Keijser

Senior Product Manager Innovative Products

3e Industrieweg 10

8051 CL HATTEM

M +31 (0) 6 225 10 361

T +31 (0)38 - 4 44 23 33

F +31 (0)38 - 4 44 64 28

E a.c.keijser@brimos.nl<mailto:a.c.keijser@brimos.nl>

S www.brimos.nl<http://www.brimos.nl/>

Van: Thomas Karner

Verzonden: dinsdag 2 augustus 2016 13:51

Aan: Keijser, Andre <Andre.Keijser@brimos.nl>

Onderwerp: Re: - I have just installed QLik Sense and want to connect to an Interbase server

[thkarner]

If you mean, if there are plans to provide a direct connector to Interbase database? I would say NO!

Not even for Microsoft SQL Server or Oracle there are specific connectors. So it´s very unlikely that a connector for Interbase will be writte, since Interbase is not a very common database.

But there should be no problem: Find and install an (64bit) ODBC driver for Interbase and connect with Qlik Sense 🙂

[#5]

Dear Thomas,

In the QLik Sense are the Microsoft sql and Oracle available as standard connections.

Kind Regards,

André Keijser

Senior Product Manager Innovative Products

3e Industrieweg 10

8051 CL HATTEM

M +31 (0) 6 225 10 361

T +31 (0)38 - 4 44 23 33

F +31 (0)38 - 4 44 64 28

E a.c.keijser@brimos.nl<mailto:a.c.keijser@brimos.nl>

S www.brimos.nl<http://www.brimos.nl/>

Van: Thomas Karner

Verzonden: dinsdag 2 augustus 2016 14:02

Aan: Keijser, Andre <Andre.Keijser@brimos.nl>

Onderwerp: Re: - I have just installed QLik Sense and want to connect to an Interbase server

[thkarner]

Not sure what you have installed, but standard connections (without further connectors) are

- Folder (--> to file system)

- ODBC (--> installed ODBC driver necessary, MS SQL Server is maybe automatically installed with Windows)

- OLE DB (--> installed OLEDB driver necessary, MS SQL OLEDB come maybe also with Windows)

- Web-File

That´s it what the standard provides 🙂

[#7]

Hi Thomas,

See connecten TAB in QLike sense

Met vriendelijke groet,

André Keijser

Senior Product Manager Innovatieve Producten

3e Industrieweg 10

8051 CL HATTEM

M +31 (0) 6 225 10 361

T +31 (0)38 - 4 44 23 33

F +31 (0)38 - 4 44 64 28

E a.c.keijser@brimos.nl<mailto:a.c.keijser@brimos.nl>

S www.brimos.nl<http://www.brimos.nl/>

Van: Thomas Karner

Verzonden: dinsdag 2 augustus 2016 13:41

Aan: Keijser, Andre <Andre.Keijser@brimos.nl>

Onderwerp: Re: - I have just installed QLik Sense and want to connect to an Interbase server

[Anonymous]

keijserandre

Andre below link might help you.

https://intelligentsql.wordpress.com/2014/09/23/using-the-new-qlik-sense-desktop/

Below are the videos for getting started qlik sense: If you see data modeling section it has detail explanation on how to connect to database.

New to Qlik Sense Videos

[thkarner]

Ok. I was looking on Qlik Sense Server 2.2. I assume your screenshot is from QS 3.0 (current version).

Finally you need Interbase and there I would bet that now native connector will be available within the next year. It´s just a feeling.

Why not using ODBC?

[#10]

Hi Thomas,

ODBC is an extra to maintain, thats all. The I had an aswer using the script editor, also an interesting solution.

For now thank ypou for answering all questions. Manny Thanks.

Met vriendelijke groet,

André Keijser

Senior Product Manager Innovatieve Producten

3e Industrieweg 10

8051 CL HATTEM

M +31 (0) 6 225 10 361

T +31 (0)38 - 4 44 23 33

F +31 (0)38 - 4 44 64 28

E a.c.keijser@brimos.nl<mailto:a.c.keijser@brimos.nl>

S www.brimos.nl<http://www.brimos.nl/>

Van: Thomas Karner

Verzonden: dinsdag 2 augustus 2016 14:28

Aan: Keijser, Andre <Andre.Keijser@brimos.nl>

Onderwerp: Re: - I have just installed QLik Sense and want to connect to an Interbase server