{"id":9378,"date":"2019-11-13T16:43:13","date_gmt":"2019-11-13T19:43:13","guid":{"rendered":"http:\/\/kb.elipse.com.br\/en\/?p=9378"},"modified":"2019-11-13T16:43:13","modified_gmt":"2019-11-13T19:43:13","slug":"communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/","title":{"rendered":"Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS)."},"content":{"rendered":"
The Amazon Relational Database Service<\/strong> (Amazon RDS) is a web service that enables the configuration, operation, and scalability of a relational database<\/a> in the cloud. This service provides users with several models of relational databases, such as Microsoft SQL Server, Oracle, Postgre SQL, and MySQL, among others.<\/div>\n
\n

The types of databases that are relevant to Elipse E3 users are Microsoft SQL Server and Oracle. For further information about this service, check the Amazon RDS<\/a> page.<\/p>\n

In this article, we’ll ilustrate how the communication between Elipse E3 and SQL\/Oracle\u00a0 databases created with Amazon RDS take place. For further information on how to create databases, please check the Amazon support<\/a> or access\u00a0 blogs and videos on the Internet that specialize in this subject.<\/p>\n

 <\/p>\n

Amazon RDS SQL Server<\/b><\/u><\/h2>\n

After creating an SQL Server database with Amazon RDS, the following EndPoint will be displayed:<\/p>\n<\/div>\n

<\/div>\n
\n
\"\"<\/div>\n

An EndPoint is the address for accessing the database; its function is comparable to that of an IP address at the machine hosting the database. Similarly to physical databases, the default port used by SQL Server is 1433, but this can be changed by the user. In addition to the data at the EndPoint, you will need other information:<\/p>\n

\"\"<\/div>\n

The crucial data here is the username of the database’s admin; this admin is created alongside the database. Once you have this information, you can use the SQL Server Management Studio to connect the DB to the cloud:<\/p>\n

\"\"<\/div>\n

You must add the DB’s EndPoint exactly “as is” at the Server name<\/em> field. If you change the default port, you will need to alter the Server name<\/em> field to: String_EndPoint:Number_Port<\/b>. Make sure you’re using the same credentials of when you created the database. If the configuration is successfull, you will have access to the DB:<\/p>\n

\"\"<\/div>\n

The rdsadmin <\/b>DB is an internal database used by the system and should therefore not be changed. From this moment on, you will follow the same steps that you would use for a physical database. Therefore, you will need to create a database that stores Elipse E3’s data; and although we haven’t demonstrated this in this article, you will also be able to create new users.<\/p>\n

\"\"<\/div>\n

Once you’ve finished this step, you will be able to connect the Elipse E3 to this database. For that, create a DBServer in Elipse E3 with the following configuration:<\/p>\n

\"\"<\/div>\n<\/div>\n
<\/div>\n
\n

At this stage, you will need to add the name of the database created at the Amazon RDS.<\/p>\n

Note that this procedure is very similiar to the one to connect via SQL Server Management Studio.<\/p>\n

 <\/p>\n

Amazon RDS Oracle<\/b><\/u><\/h2>\n

After creating an Oracle database with Amazon RDS, the following EndPoint will be displayed:<\/p>\n

\"\"<\/div>\n<\/div>\n
<\/div>\n
\n

An EndPoint is the address for accessing the database; its function is comparable to that of an IP address at the machine hosting the database. Similarly to physical databases, the default port used by SQL Server is 1521, but this can be changed by the user.<\/p>\n

\"\"<\/div>\n

At this stage, what distinguishes an Oracle database from an SQL database is the field DB Name<\/em>, in addition to Username<\/em>.\u00a0 This happens because, unlike SQL Server DBs, Oracle databases are not created by the Management Studio, and are actually instanced inside the Amazon RDS system.<\/p>\n

In addition to this configuration, you must also make sure you have the Oracle Client 32 bits<\/b> installed in the same machine as Elipse E3 so that it can connect to the database in the cloud.<\/p>\n

Once all these requirements are met, the connection will happen as described in the procedures below.<\/p>\n

 <\/p>\n<\/div>\n

Connection between Elipse E3 and Amazon RDS Oracle<\/h3>\n
First of all, you will need to open the Net Configuration Assistant<\/b>, which has been installed alongside the Oracle Client.<\/div>\n
<\/div>\n
Then, select the option\u00a0 Local Net Service Name configuration<\/b> and click Next<\/b>.<\/div>\n
<\/div>\n
\n
\"\"<\/div>\n

To create a new connection, select Add <\/b>and click Next<\/b>.<\/p>\n

\"\"<\/div>\n

Add the name of the database created at the Amazon RDS.<\/p>\n

\"\"<\/div>\n

Select the option TCP <\/b>and click Next<\/b>.<\/p>\n

\"\"<\/div>\n<\/div>\n
<\/div>\n
\n

Add the DB’s EndPoint. If you want to change the default port, you will need to do so at this stage.<\/p>\n

\"\"<\/div>\n

Test the database in order to check if all information were typed properly. To do so, click Change Login<\/b> and add the credentials of the admin user configured when you created the database.<\/p>\n

\"\"<\/div>\n

After completing the process successfully, you will need an alias for the newly created connection. You will use the same alias when setting up the Elipse E3 database.<\/p>\n

\"\"<\/div>\n

At the end of the process, you will need to create this object in Elipse E3 and set it up as following:<\/p>\n

\"\"<\/div>\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

The Amazon Relational Database Service (Amazon RDS) is a web service that enables the configuration, operation, and scalability of a relational database in the cloud. This service provides users with…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735,730],"tags":[955,956,957,958],"yoast_head":"\nCommunication between Elipse E3 and Amazon RDS.<\/title>\n<meta name=\"description\" content=\"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Communication between Elipse E3 and Amazon RDS.\" \/>\n<meta property=\"og:description\" content=\"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-13T19:43:13+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5488\/endpoint_sql.png\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS).\",\"datePublished\":\"2019-11-13T19:43:13+00:00\",\"dateModified\":\"2019-11-13T19:43:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\"},\"wordCount\":778,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"keywords\":[\"amazon rds\",\"amazon relational database service\",\"oracle\",\"sql server\"],\"articleSection\":[\"DataBases\",\"Elipse E3\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\",\"name\":\"Communication between Elipse E3 and Amazon RDS.\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-11-13T19:43:13+00:00\",\"dateModified\":\"2019-11-13T19:43:13+00:00\",\"description\":\"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS).\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Communication between Elipse E3 and Amazon RDS.","description":"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/","og_locale":"en_US","og_type":"article","og_title":"Communication between Elipse E3 and Amazon RDS.","og_description":"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.","og_url":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-11-13T19:43:13+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5488\/endpoint_sql.png"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS).","datePublished":"2019-11-13T19:43:13+00:00","dateModified":"2019-11-13T19:43:13+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/"},"wordCount":778,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"keywords":["amazon rds","amazon relational database service","oracle","sql server"],"articleSection":["DataBases","Elipse E3"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/","url":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/","name":"Communication between Elipse E3 and Amazon RDS.","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-11-13T19:43:13+00:00","dateModified":"2019-11-13T19:43:13+00:00","description":"This article shows how to establish communication between Elipse E3 and SQL\/Oracle databases created at the Amazon RDS environment.","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/communication-between-elipse-e3-and-amazon-relational-database-service-amazon-rds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS)."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/9378"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=9378"}],"version-history":[{"count":5,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/9378\/revisions"}],"predecessor-version":[{"id":9383,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/9378\/revisions\/9383"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=9378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=9378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=9378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}