Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Endpoint for Amazon RDS datasource
Migrateduser
<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>
Find more posts tagged with
Comments
There are no comments yet