Endpoint for Amazon RDS datasource

BRM

<p>Hello,</p>
<p>I am working with BIRT iHub 3.1.  My database is an Amazon RDS MySQL instance.  When I develop reports in BDP 4.4 I can use</p>
<pre class="_prettyXprint">
mydomain.blahblahblah.us-west-2.rds.amazonaws.com:3306
jdbc:mysql://mydomain.blahblahblah.us-west-2.rds.amazonaws.com:3306/myDB?noDatetimeStringSync=true </pre>
<p> as a database URL to connect to the instance, the hostname being given by RDS in the management console for the instance.</p>
<p> </p>
<p>However reports with the above URL will not work when they are uploaded to iHub. I have to use the DB URL</p>
<pre class="_prettyXprint">
jdbc:mysql://12.34.56.789:3306/myDB?noDatetimeStringSync=true
</pre>
<p>to get reports to run in iHub, where I use the actual physical IP address of the instance.  </p>
<p> </p>
<p>All of this would not be a problem except the IP address of the instance recently changed and so I had a lot of reports to update.</p>
<p> </p>
<p>This feels to me like a driver issue, but I could be wrong.  Can anyone help me out or point me where I might look to be able to use the hostname and not the actual IP?</p>
<p> </p>
<p>Thanks in advance.</p>
<p> </p>
<p> </p>

JFreeman

<p>This sounds to me to be a DNS related issue with the DNS server used by the machine where the iHub is installed.</p>
<p> </p>
<p>The best solution is to work with whoever maintains the DNS server to have it include your AWS instance. However, an alternative would be to add an entry into the hosts file on the iHub machine that points to your AWS instance. Then, if the IP address changes again, you only need to modify the host file and not all of the reports.</p>