SAS Enterprise Guide vs. Oracle sql developer

[alvarogalo1993]

Good morning,

I am new to SAS and so far I have always used Sqldeveloper from Oracle, could someone tell me pros and cons of each or differences. In SAS we have libraries that target each bbdd and we have detected some disadvantages like:

• Bad response times in :
  • Slow login
  • Opening library folders slow
  • Retrieving a large table slow
  • Opening a project...
• To visualize the queries that are executed in a project, you have to go into each of them to see the filters, crosses, etc...
• If it disconnects from the network, you lose the execution of what you are doing and you have to start from the beginning, with a new login, open folders, tables,....

I don't know if these problems can be mitigated somehow?

Thank you very much to all.

Best regards.

[Ksharp]

SAS and Oracle are totally different product.
SAS is a data analysis software, you can build model (statistic or AI or Machine Learning) on data.
SAS Enterprise Guide is just a GUI of SAS . (CS construction a.k.a Client Server)

Oracle is a Database which can store and analysis data(unlike SAS, it only can do some very basic summarize analysis).
Oracle have many features than SAS to manage data , SAS is quite sample .

@ChrisHemedinger could give you more info ,who lead the development of SAS Enterprise Guide .

[SASKiwi]

We use EG and its definitely not slow as long as the network between the SAS servers and the EG PC performs reasonably. If you are working remotely and in particular using VPN then it can be slow but that isn't the fault of EG - a slow network will result in slow EG performance. If you think performance is slower than it should be then open a SAS Tech Support track to diagnose this.