Book a Demo

Author Topic: 2 simple question about Cloud Service not in help  (Read 6190 times)

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
2 simple question about Cloud Service not in help
« on: July 30, 2015, 01:33:23 am »
I have 2 simple questions about the Cloud Service that are not clear in the help/documentation:

1) Is it required to use IIS with Cloud Service? or is it optional.
2) When connecting EA to a Cloud based repository, in the field "Model Name", what is supossed to be input? The model itself has no name. The database (MySQL, in my case) has a name, but not the model. It seems not to work with the database name.

OpenIT Solutions

  • EA User
  • **
  • Posts: 555
  • Karma: +9/-1
    • View Profile
Re: 2 simple question about Cloud Service not in h
« Reply #1 on: July 30, 2015, 02:36:29 am »
- IIS is optional.
- the model name is the name at the end of your connection string defined in the cloud service client.
« Last Edit: July 30, 2015, 10:02:51 pm by openit »

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: 2 simple question about Cloud Service not in h
« Reply #2 on: July 30, 2015, 08:03:30 am »
Thank you.  But in the cloud service client there is no place to input this name, so I don't really know what this name is

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: 2 simple question about Cloud Service not in h
« Reply #3 on: July 30, 2015, 08:36:39 am »
It's the name you give the datasource in the ODBC data sources administrator. (For any ODBC datasource)

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: 2 simple question about Cloud Service not in h
« Reply #4 on: July 30, 2015, 03:43:27 pm »
And what if the connection is not via ODBC but, for example a SQLServer connection? what is the name in this case?

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: 2 simple question about Cloud Service not in h
« Reply #5 on: July 30, 2015, 04:42:17 pm »
Quote
And what if the connection is not via ODBC but, for example a SQLServer connection? what is the name in this case?
I didn't answer that because you specified MySQL. Okay, the non-odbc names are the following.

  • Firebird repositories are most often files in the cloud service directory. The model name will match the file name.
  • Oracle repositories can be accessed using an OLE DB connection or an ODBC connection.

    If the database manager shows:
    oraoledb.oracle.1:user@mymodel
    Users will enter "mymodel" as the model name in the connection dialog. Note that this means a cloud server can't connect to multiple schemas on the same database via OLEDB.

    Alternatively, if the database manager shows:
    msdasql.1:anonymous@my model
    Users will enter "my model" as the model name in the connection dialog. Note that this allows connecting to multiple schemas within the same database.
  • SQL Server repositories can be accessed using an OLE DB connection or an ODBC connection.

    If the database manager shows:
    sqloledb.1:sa@server\instance.mymodel
    Users will enter the database name, "mymodel" as the model name in the connection dialog.

    Alternatively, if the database manager shows:
    msdasql.1:anonymous@my model
    Users will enter ODBC connection name, "my model" as the model name in the connection dialog.

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: 2 simple question about Cloud Service not in h
« Reply #6 on: July 31, 2015, 04:44:17 am »
Thanks!