Objects

prabhas277 — Wed, 27 May 2015 16:26:44 GMT

Hi experts,

What is extension object and custmized object? And

I have 2 tables T1 name as EMP, T2 name as EMPORDER. Now i want load T1 table from SQL and t2 table load from PLSQL.how we can achive this?

Re: Objects

Qrishna — Wed, 27 May 2015 16:48:20 GMT

ODBC CONNECT TO (Yor SQl server connection);

Emp:

Load A,B;

SQL SELECT *

from T1;

Disconnect;

ODBC CONNECT TO (Yor PLSQl server connection);

EMPORDER:

Load C,D;

SQL SELECT *

from T2;

Another Work Around is to Store the Connection strings in text file with .qvs extension and use them in qlikview with the help of inlcude statement.

Eg:

Store the below connction strings in text files and change the file extension from .txt to .qvs

ODBC CONNECT TO (Yor SQl server connection); in Sql.qvs

and

ODBC CONNECT TO (Yor PLSQl server connection); in PLSql.qvs

Now in your Qlikview.

Use:

EMP:

SQL

SELECT A,B

$(Include=..\_data source\Sql.qvs). T1;

EMPORDER:

SQL SELECT

C,D

$(Include=..\_data source\PLSql.qvs). T2;

HOPE THAT HELPS.