UEM Application Profiler with Oracle SQL Developer

[GarTomlon]

I am curious if anyone has been able to successfully profile Oracle SQL Developer.  I have been trying for the longest, however, with no success.  Whenever a user creates a connection to a server and save it.  That connections or settings are no longer present when they log off and back into their VDI session.  Please any help is appreciated.

[Ben_SVB]

I have the same issue, seems like UEM is not pulling the APPDATA for the SQL Developer folder.  However i cant get it to pull the data.

[IncludeRegistryTrees]

HKCU\Software\JavaSoft

[IncludeFolderTrees]

<AppData>\java

<AppData>\SQL Developer <-- Exists in here

<AppData>\sqldeveloper

[DEMdev]

Hi Ben_SVB​,

seems like UEM is not pulling the APPDATA for the SQL Developer folder

What exactly do you mean? Does the information get correctly exported to the profile archive? (That is, when you manually extract the profile archive, do you see the file(s) you're expecting?) Does the information not get correctly imported again at the next logon?

[Ben_SVB]

So i started to do extensive testing on this today.  It might be the way that SQL Developer is creating the folder in %appdata% directory.

If you launch the application from clean it will capture

%appdata%\sqldeveloper

this mainly contains the startup and import data when the program first launches.  If you make any configuration changes to this app they do get created in %appdata%\SQL Developer, however DEM is not pulling the data to that profile.

However if you close the application after initial setup, reopen it again, then make your config changes, it will find the %appdata%\SQL Developer folder and pull those changes and store to the profile.

So at this point i dont know if it is how SQL Developer is creating the folder, or how UEM is not seeing it the first go around.

Hope that helps.

[DEMdev]

Hi Ben_SVB,

I'm sorry, it's still not clear to me.

What does your Flex config file look like? Can you provide a FlexEngine log file at log level DEBUG, covering a full session from logon to logoff?

[Ben_SVB]

Sorry due to security I am prevented from posting logs in a public forum.

[sjesse]

If that's the case I'd open a ticket with support.

[Ben_SVB]

I would but i am not having a problem anymore.  I was just trying to help the OP.

[sgjaszkowski]

I am having the same issue.  Saved or imported SQL connections are not saving.  Did anyone find a solution for this?

[Shreyskar]

Hi sgjaszkowski

I have resolved this following below steps:

1) Make sure Oracle flex config look like below in UEM manager:

[IncludeRegistryTrees]

HKCU\Software\JavaSoft

[IncludeFolderTrees]

<AppData>\java

<AppData>\SQL Developer

<AppData>\sqldeveloper

2) Do not use Directflex on Oracle flexconfig file. If it is enabled, disable it and set the export moment to 'Export at logoff'. In my case it was enabled, I then disabled it.

3) Remove all your existing Oracle zip files from UEM profile share repository 'archives' folder.

4) Login to the VDI and make all changes like setting preferences and create database connections.

Note: Oracle SQL developer saves the DB connections under 'connections.xml' file and preferences under 'preferences.xml' filder under %appdata%\SQL developer.

5) Close the oracle SQL application and open it after a min within same session. Make sure the preferences and settings are persistent within the same session. If it is not, UEM won't be able to capture it on logoff.

6) Logoff and login back, it should work now.