Qlik connect to a postgres fdw

AleksandrS — Mon, 21 Oct 2019 14:49:50 GMT

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?

Re: Qlik connect to a postgres fdw

MaWi — Wed, 24 Feb 2021 10:56:47 GMT

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

topic Qlik connect to a postgres fdw in App Development

Qlik connect to a postgres fdw

Re: Qlik connect to a postgres fdw