Database Connection Version Control | Community

Hi,

I am trying to version control the database connections that we have on our FME implementation, I have a docker setup. Unfortunately I can't find the files where these are stored, the host OS is centOS. Any chance you can point me towards the correct path where these are stored?

(I use the default mounts that come with the compose file)

Thanks!

Regards,

Miguel

Page 1 / 1

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

Unfortunately that search wasn't fruitful, searched through me containers and couldn't find it.

Thanks for the suggestion though

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

Hm, too bad. Hopefully someone from Safe can chime in here, I'll try to get their attention to this post.

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

Thanks @david_r!

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

Btw, since you're mentioning Docker this concerns FME Server, right?

If so, the named connections are stored in the internal database. On a default installation this is in the PostgreSQL database "fmeserver" and the tables starting with fme_nc_* (as far as I can tell)

It's saved in your user profile as a SQLite database. On Windows it's here:

C:\Users\<username>\AppData\Roaming\Safe Software\FME\fme_connections.data

Hopefully someone else can be more specific for your particular case. Maybe try searching the file system for "fme_connections.data" and see if it shows up?

@antunesm - check Tools > FME Options > Default Paths in FME Workbench. The Data Path should tell you where data is being stored. That's where the connections file should be held:

@antunesm - @david_r is correct that in FME Server deployments, the named connections are stored in the database in tables starting with "fme_nc_", not in a file.

In a docker deployment if you need direct access to the database, you can map the port 5432 from the container to a port on the host and then you could query the FME Server database directly. You can do this by adding:

ports:
 - 5432:5432

to the "fmeserverdb" service in the docker-compose file. You can then connect to the database on that port on your physical host that the container is running on.

As for version controlling a database table, I am afraid that is beyond my expertise. It isn't as easy as if the connections were stored in a file...

Reply