Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Qlikview and Sybase

Hi All,

How do i connect to sybase?

are there are any connectors available?

Thanks in advance. . .

Regards,

Viraj

1 Solution

Accepted Solutions
bbentzen
New Contributor II

Re: Qlikview and Sybase

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 Replies
Not applicable

Re: Qlikview and Sybase

Hi,

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

regards

Not applicable

Re: Qlikview and Sybase

Thanks Krunoslav,

Do those work with Sybase IQ, a columnar DB?

Thanks in advance. . .

Not applicable

Re: Qlikview and Sybase

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

bbentzen
New Contributor II

Re: Qlikview and Sybase

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

bbentzen
New Contributor II

Re: Qlikview and Sybase

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

bbentzen
New Contributor II

Re: Qlikview and Sybase

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

Not applicable

Re: Qlikview and Sybase

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

Not applicable

Re: Qlikview and Sybase

Thank u all . . :-)

Community Browser