Export/Import Data Source Config. or connection

[ecsgz]

hi,

I have one MySQL database, on which I have the EA datamodel. I have only configured one admin database access, for some reasons, it is not possible to add further database users with restricted access rights.

Based on that, I want to allow read access to further EA users, but without telling them the database admin password, which is needed to build a connection to the EA datamodel I want to allow read access to (if the further users know the database password, they have the possibility to access database by any other database client if they want, this is what i want to prevent)..

So, is it possible to export either
- MySQL Connector/ODBC user data source configuration or
- Connection data link?

Or is there any other good solution on that without adding further database users and without telling the database password?

[Geert Bellekens]

yes, create a model shortcut (File|Save Shortcut...) and select the option to encrypt the connection string.

That will create a "shortcut" .eap file that users can click to open the model.
The database password is stored in the file in an encrypted way so it cannot be read by a user.

Geert

[ecsgz]

Thank you, exactly what I was looking for!

So can I go further and provide that shortcut to all kind of users and make it that way easy to users to establish directly connection to data model without the need to add & create ODBC data source and data link connection manually?

The read or read/write restrictions for each user would be done then only by EA security and user management?

[Geert Bellekens]

That is indeed a "best practice" setup.

Geert

[ecsgz]

Thanks again for your reply!

That shortcut solution currently works only for me without problems.

I have (already) added the different users using EA Security with Windows Login Authenitcation. The users also did install the MySQL ODBC driver...

Everything works fine when doing it without the shortcut. But with the shortcut, the user, even being added with EA Security, is asked to enter a password. What kind of password is that? Windows Login password doesn't work...

Can you help me again?

[Geert Bellekens]

If you are only asked for a password then the connection to the database was not successful.

The same thing happens when the database is down, or you don't have the correct driver, or...

Geert

[ecsgz]

taken from the shortcut:

"EAConnectString:eadb_admin_connection --- DBType=0;ConnectEx=[...]"


The users receiving the password problem use:

Desktop: Windows 7, 64 Bit
EA (32 Bit) Version: 11.0.1106
MySQL ODBC driver (32 Bit) Version 5.1.5 (as recommended by EA)

Community MySQL Server Version: 5.6.17 (@server, 64 Bit)

As I said, no problems at all when NOT using the shortcut! Because of that, I exclude database problems (not down) or wrong driver problems.

Something doesn't work properly when using shortcut connection...

[qwerty]

You might ask Sparx' support via mail. They are quite responsive when it comes to such sort of issues.

q.

[Dermot]

If you have either EA version 11 or 12 the simplest solution is to use the Cloud Service.  With this:
 - The ODBC set up is external to the user
 - The read-only users can be allocated a specific port for read-only access
 - It can be used external to your LAN
Also note that read-only access to the Cloud repository can be by using EA Lite (free), that can be downloaded from the Registered user section of our web page.
 
For more Cloud information see:
http://www.sparxsystems.com/products/ea/11/index.html#deployment