so in previous videos we showed how you
can set up a cloud sequel database and
how you can build the connection string
to work with that database in alpha
anywhere in this video we're going to
show how you can work with your cloud
database using the familiar tools that
you normally use to work with your
sequel database so for example in the
case of moriah DB we're going to use
navigate to connect and work with our
cloud database so we're going to go here
first of all and go over to actions and
the first thing we're going to do is
we're going to basically open the SSH
tunnel if it's not currently open you
can see how it already is open so then
we're gonna go here and say get SSH
tunnel details and I'm going to just
copy those to that report so this tells
me the information I'm going to need in
order to use navigate to connect to the
sequel database so I'm going to just go
and put this in a text file so that I
have access to it later on and now I'm
gonna go back to navigate over here so
let's go over yet you guys know the cat
and I'm gonna create a new connection so
I'll say new my sequel connection the
connection name I'll just call it cloud
moriah DB it's a localhost and then you
can see over here that when we copied
when we looked at our SSH details that
told that the port was 5-3 306 so we'll
go here and type in 5-3 306 the username
was root and I'm gonna just copy the
password that was shown in the SSH
details and paste that over there and
then go ahead there and test my
connection so there the connection has
been opened and so now we have a new
connection in in navigate there I double
click on that I can see in the Northwind
database here all of the tables that we
have if I go for example in
the customer table there's the data in
the customer table so we're working with
this cloud database right now in
navigate but we can only connect to this
cloud database while Elfi anywhere is
open and the SSH tunnel is open the
sooners would closed alpha anywhere down
the SSH tunnel is automatically closed
and we won't be able to use navigate
until we go back and reopen the SSH
tunnel so what we've shown over here is
how you can use your standard
development tools for working with your
cloud database in the case of variety be
that would be navigate in the case of
sequel server that would be sequel
server management studio in the case of
Postgres that would be whatever tool you
like to use for Posterous it could be
Navigant or PG admin etc thanks very
much for watching
Customer Support