Project Shortcut to Oracle based RDBMS Repository

[JohnDoe]

Hi,

we have setup a EA-Schema on an Oracle-Database.
We can connect manually with the Repository, but we need to create manual DNS (=Windows DataSource) on every single machine to connect to Oracle.

Our scenario is, that every user should install EA, the latest Oracle driver version and use a shortcut link to connect to our Oracle based EA model by double clicking the icon on the desktop.

Is it possible to connect to Oracle repository, create a project shortcut file by using "create shortcut" in EA and distribute this link to all users, so they can double click and enter the oracle repository ?

We have tried different "server connection" settings (IP adress and port, tnsnames connection string etc.), but we were not able to create a shortcut, which can be distributed and used by others. It only works if every one installs a Windows Datasource or entry in tnsnames.ora.

Is it possible to connect to an Oracle-Database using a Project Shortcut, where you dont need to edit tnsnames.ora or create a DNS Datasource on every EA users machine ?

Thanks
Joe

[Eve]

I'm by no means an Oracle expert, but one option you have is to use the cloud service.

This means EA clients don't even need to know that it's an Oracle back-end. (And you can create a link that all clients can use)

[JohnDoe]

We are talking about an intranet solution for 50+ software architects. Our company will never place information on servers residing outside the company.

I have seen a solution already, but dont know how to create a shortcut to Oracle without using DNS DataSource or tnsnames.ora entries.

If someone knows how to connect EA to Oracle database using a connection string, it would be very welcome.

[Eve]

Just to be clear. When I mentioned the cloud service, it's a windows service that runs on a server you control and provides access to a model over http. It doesn't need to be exposed to external networks at all.

Given that it's on an intranet, you don't even need to set-up https or authentication. Just point it at your Oracle model(s) and point EA clients at it.

[JohnDoe]

Sorry, for security reasons all our servers are unix based.

We are talking about an example for a working connection string, which I should enter when using the wizard or connection string feature of EA.

[Eve]

Okay, sorry I couldn't help.