Scripting and running SQL via the Cloud service

[Guillaume]

Hi,

I have a custom VB Script in EA that exports selected data in an Excel file within several tabs (e.g. classes, attributes, connectors...)
It uses SQL queries that work fine via the ODBC link to the DB. When using the Cloud Service, the script fails exporting some of the data.

I have yet to investigate into details what's going on, but I was wondering if anyone had experienced a similar issue. Does the Cloud Service introduce issues in such scenario?

Thanks
Guillaume

[PeterHeintz]

This is something I want to look on, as well (up to now I just did not find time).

However I am absolutely sure that Cloud Service introduces some issues.
Without Cloud your users need access to the SQL server, but with cloud the users do not need that rights (what is in some cases a good thing).

Maybe I am wrong, but my feeling tells me that the hopping from EA SQL Select ->Cloud http->SQL server SQL Select->SQL server Sql Response->Cloud Http->EA SQL Response might be neither implemented in EA nor in the Cloud Server.

[Geert Bellekens]

Some users have reported some issues with regards to the quick search in the EA Navigator on a cloud server.
Still have to investigate and possibly report a bug. But apparently using the cloud service is not as transparent to the API as it should.

Geert

[Guillaume]

I found the issue ! I'm testing the DBType value in the connection string so when I detect a Postgres DB, I'm running a Postgres specific SQL function.
When I use the Cloud Service, the returned connection string is ea--- ;Connect=Cloud=protocol:http,address:A.B.C.D,port:804;Data Source=EA;DSN=EA;

Hence I have no way of finding out the DBMS running behind the Cloud Service...

My workaround for the current project is to set DBType = 4 for all Cloud accesses as my client only uses Postgres behind the Cloud. However for addin solutions, I can't see a solution unless sparx can amend the Cloud Service to return the DBType in the connectionstring.

[Eve]

Repository.RepositoryType()