Qlikview and Sybase

[#1]

Hi All,

How do i connect to sybase?

are there are any connectors available?

Thanks in advance. . .

Regards,

Viraj

[#2]

Hi,

there are two options: using ODBC or OLE DB driver. Both are provided by the Sybase.

regards

[#3]

Thanks Krunoslav,

Do those work with Sybase IQ, a columnar DB?

Thanks in advance. . .

[#4]

I don't have experience with Sybase IQ (it seems it does not have relational structure); maybe if someone else can answer on this question.

regards

[Anonymous]

Hi,

Even though Sybase IQ is a columnar database, it is still fully relational, ODBC and JDBC work fine with Sybase IQ (don't know about OLE DB since I don't use this).

Sybase IQ fully supports ANSI SQL.

Regards

[Anonymous · Accepted solution]

Hi,

Even though Sybase IQ is a columnar database, it is still fully relational, ODBC and JDBC work fine with Sybase IQ (don't know about OLE DB since I don't use this).

Sybase IQ fully supports ANSI SQL.

Regards

[Anonymous]

Hi,

Even though Sybase IQ is a columnar database, it is still fully relational, ODBC and JDBC work fine with Sybase IQ (don't know about OLE DB since I don't use this).

Sybase IQ fully supports ANSI SQL.

Regards

[#8]

Use proper drivers version from Sybase (sybase website) and connect through ODBC. It work out fine. I have tested with sybase 12.5.

[#9]

Thank u all . . 🙂