Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have Postgres foreign data wrapper.
I installed Qlick sense Desktop.
Qlik connected to postgres complete, but postgres_fdw qlick not view data.
I see scheme, but no data in tables.
Maybe there is a special odbс driver?
I run in the same problem.
Finally i figured out, that only the PostgreSQL table_types "VIEW" and "BASE TABLE" are listed in the Qlik data manager. Foreign Data Wrappers (FDW) are in PostgreSQL internally signed as "FOREIGN". Thats seem to be the reason why they are not listed.
But if you have set the correct access rights, then u can use them, although you dont see them: just try to make a simple SQL SELECT * FROM {my_fwd_table} and u will get all the data out of your FDW.
Regards
MaWi