Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
thanstad
Creator
Creator

Running Decrypt SQL package from QlikView

How to access a PL/SQL package from QlikView ? Well you probably think this must be done in PL/SQL prior to you load from the Oracle tables. This is in many situations good enough to provide the decrypted information the day after, typically in you datawarehouse. In this case, it should be a application controlled by the user and reloaded by EDX. The nice about this, you can directly from you application, make a nested select in the SQL you parsing to Oracle. This will access your package in the same way as in offline mode. I found this ability in QlikView very powerful and it gives the developer and enduser much more flexibility and it saved us from an IT request and 6 months waiting on the new field. 

Tormod Hanstad

Tech. Analyst BI,CRM

Canal Digital Norway A/S

0 Replies