FME desktop VDB connection

For those of us that don't know, what is a "VDB connection"? I can't find anything by that name in the FME reader/writer gallery.

VDB for virtual database, in my case Teiid. I havn't find anything about that in the gallery.

I don't know that format at all, but hopefully section 1.1 Driver Connection on this page can help you with the connection string and java driver class name for the JDBC reader/writer.

Thx for the answer, but the question now is, how to use that on FME ? Wich format can I use on my reader ?

Try the JDBC reader, my guess would be something like this:

Obviously the parameters above are made up, I haven't got an instance of Teiid to test against.

I havn't JDBC format on my gallery :( that's the problem

Ah, I didn't notice that you were on FME 2013. You'll have to upgrade as the JDBC support was introduced with FME 2015.0

You can download the latest version of FME here:

http://www.safe.com/support/support-resources/fme-downloads/

Or older versions here:

http://www.safe.com/support/support-resources/fme-downloads/archived/

If you need to preserve your old version you can simply install a newer version of FME in a separate directory, they will coexist nicely.

Humm I'll see if we can upgrade our FME version but I don't think so. I mean we could but we'll have to upgrade our server etc...

I'm trying to initiate a reader with the Postgre format and it almost worked :

But, I've an error on the "Constraints" section, any information about that ?

Here is the error :

Thanks by advance

Make sure that the "powerbi" user has sufficient rights, in particular SELECT rights on the "pg_tables" object.

Hi,

Yes the user has sufficient rights. We'll upgrade our version to 2015.

Thanks for your help :)