Data Connections disappeared in the Data load editor

[OlivP]

Hello,

My connections to ODBC connections and API's connections "disappeared" in Qlik Sense (Nov 2018 version), in the load editor view. I can't use it anymore (the database is up and running and credentials are OK).

They are still visible  in QMC/Data Connections..

In debug mode, the connection fails (probably because the connection is "unknown"?).

If I make a copy of the data connection, it works for a short time, and it disappears again.

I thought it was sort of a cache problem, but I can't find anything to clear it for ODBC connectors.

Does someone has an idea? Or already had this issue?

Thanks guys for your precious help!

[Jill_Masinde · Accepted solution]

@OlivP 

Check for custom security rules that could make the data connections invisible?

https://community.qlik.com/t5/New-to-Qlik-Sense/Data-Connectors-Disappeared/td-p/117408

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-dat...

[OlivP]

Thanks for your answer!

The problem came from the "DataConnection" Security rule in the QMC.

The only possibility I had was to create a database, not seeing all of them; so we add the "Read" rights.

Now I am able to see the data connections!