Publish local database in presto cloud

  • milandoj
  • 05/05/10
  • Offline
Posted: Sun, 08/22/2010 - 17:08

Hello everybody!

I have local MySQL database and I want to use its data in Presto cloud like mashable.

Is it possible to publish the database somehow?

I tried: Register->Database and then I dont know how to continue.

Or is it possible to create database instance in presto cloud alone?

 

Thanks for the answer,

Milan

cfff4
0
Your rating: None

 Hi Milan, You must first

  • john.crupi
  • 09/19/08
  • Offline
  • Sun, 08/22/2010 - 17:23
  • Copy comment link

 Hi Milan,

You must first register the database within the Admin Console. Only admins can do this. If you want, I can add it, but it will be viewable by others in the MDC community.

Let us know.


And it is now possible to

  • milandoj
  • 05/05/10
  • Offline
  • Sun, 08/22/2010 - 17:40
  • Copy comment link

And it is now possible to publish my database data with a mashup script where in the <datasource> element I will specify the url of the database something like: url="jdbc:mysql://localhost/databasename", together with some mashup operation that will query some data.

If I publish this scritp on presto cloud, will it work? Probably it will work only to people that will have the same propreties for the database and also the database at localhost?Am I right?

If it is not possible to query data from my local database in the cloud, which information you need to register a database in the cloud?

Thanks


 Hi, Since Presto is running

  • john.crupi
  • 09/19/08
  • Offline
  • Mon, 08/23/2010 - 12:37
  • Copy comment link

 Hi,

Since Presto is running on the cloud, it would need to access your external IP, not localhost. If you open the database IP and port, then you will be able to put the datasource in your EMML script.