How to Connect Databases in Aqua Data Studio

Hello and welcome to a demonstration video about Aqua Data Studio and really how to get started, right? How to download, install, activate, and then connect to a database and dive in and let you start using the product if you are brand new to Aqua Data Studio. Aqua Data Studio a productivity software for database developers, DBAs analysts, really anyone that needs to connect to a database and work with data. We’ll introduce the site in this presentation, but I just wanted to maybe start there if you’re hearing about the product for the first time. Okay, so I have some PowerPoint slides to go through, then we’ll actually run through the installation. Ultimately, the product is a productivity tool to let you do your job. You’ll have a configured environment in terms of where you’re connecting to and different color coding menus, and again, allowing you to move quickly in terms of getting to data and taking actions on your data or working in a database, depending on your responsibilities.

Installing Databases

This is what Aqua Data Studio might look like once you’ve started using the product. For the sake of this presentation, I’ll step through Dan install in a new environment, and we’ll go through an example of how to actually connect to a database. Okay, let me switch back to the PowerPoint slide and get started there. Okay, so the first slide here just as an overview of where to download Aquade Studio. You might be on the Aquafold site already. Otherwise has easy links and downloads. There’s also some support sites once you become familiar with the site. Just basically different areas to download the executable. And we’ll show some examples of that. Aquidatastudio is a Java application, which means it can install on different operating systems, different client operating systems, right? Of course the Windows operating system is supported, but if you work on a Mac, that’s fine.

Aqua Data Studio for Mac or Linux

Aqua Data Studio can install on a Mac, even a Linux client. In terms of downloading, you’ll have choices in terms of what executable you’d like to download, different versions for the different operating systems. I added the compressed selection there because you can run the product from a zip folder. For perhaps consultants that might have limitations in terms of where they can install, that’s a benefit. And a productivity area within Aquative Studio. Very flexible in terms of where you can install and use the product. This has been developed for many years now. These areas that customers have helped help us improve in terms of easily download, easily install, and let you dive in and start using the product. Okay, so we’ll introduce some of these pages on the website, but there’s just the parent page, You see the green boxes where you can easily download and install the product.

It does install in seconds. We’ll step through that example, but again, that’s really one of the benefits is allowing you to quickly connect and then move forward and achieve your job responsibilities. Here’s the download page that we’ll look at. You can see the choices for Windows, Max and Linux and then also wanted to point Oct here the side by side option, right? If you have a previous version, you can install the new version without removing that’s fine. Or you can just choose to upgrade the existing installation directory. All right, so here’s just the save as we’ll step through that where you can choose your directory path, the executable to save or run it on the fly. Pretty standard in terms of those choices there. Again, once you’re familiar with the site, you have some internal directories as well. Okay, so we’ll actually run through these installation steps, but just to show what we’re about to look at, probably half a dozen or so windows that you’ll click through for the installation.

Installing Aqua Data Studio

Very familiar standard types of installation windows choose where you’re installing what directory path, the shortcut menu on your desktop, on the Start menu. Ultimately that would create a desktop, an icon on your desktop that you can launch by double clicking or it would be in your application menu as well. Okay, once you open the product for the first time, there’s a couple of steps. That is just a one time only, right? There’s the concept of activating the license key. There’s a trial evaluation for two weeks or 14 days, or you can plug in a licensed key. If you have a license key, the next window here would show some of those choices. Once you open the product or either an evaluation or commercial, you activate, right? That’s just a window or step to point out here. You either click on the activate button and it activates that trial or the commercial version.

Connect to a Database in Aqua Data Studio

That needs the machine to be online, right? That’s the concept to share in terms of activating. But there is this manual activate. If you have a machine that’s not online for different reasons or security reasons, there’s a way to activate the license there as well. This is documented on the internal website or the Aquafold site where you can learn more about that. But basically this is pretty straightforward. I don’t want to overcomplicate things here. When you first open the product and activate the product, it will say, okay, you haven’t connected to any databases yet, would you like to register a server? That’s some terminology even to share connect to a database. It’s called Register Server. Here Aqua Data Studio. There’s the server menu and the Register server. Clone server. We’ll step through an example of these as well. All right, just another screenshot or two here.

As you might expect, the very first icon on the main toolbar is Connect to a database, right? So register servers, the very first icon. There’s the concept of grouping servers in some kind of way that makes sense for you in terms of where you’re responsible for or naming conventions. You have flexibility there in the server groups concept. Again, we’ll look at these within the Live application. Here’s an example of where you can connect to a database and choosing the database platform and then seeing how those population boxes would vary in terms of what is needed to connect there. A lot of effort developments go on to this window, and we’ll look at examples there. This is connecting to a database. In this example, I’m highlighting the SQL Server selection. You have the ability to connect to Excel spreadsheets and work on that data as well.

That’s a choice and maybe an example that we’ll look at. How to connect to a database, how to connect to an Excel spreadsheet or a directory that’s holding your Excel data. Of course, there’s import and export capabilities. If you have data in Excel that you’d like to bring into a database, that’s a core feature. Aqua Data Studio itself, but probably beyond the scope of what we’ll look at here today. Today we’ll look at just connecting to a database or connecting to your Excel data. All right, so here’s the agenda that will go through. I’ve downloaded the Windows executable. So we’ll kick that off. We’ll run through the install on Windows, which just takes a few seconds. And so we’ll look an example there. And then the activate. Again, don’t want to overcomplicate things. That’s a window that will prompt when you first open up the product.

I think the screenshots will cover what I need to address there. There’s ways of just talking to us with the link from the help licensing menu. The last step there is diving in, right? How do you connect? How do I populate my list of databases that I connect to? Maybe a little more advanced is actually sharing a connection file. If you had a colleague and you need to share a connection file, or ultimately if you’re managing different environments, the connection file is an easily configurable transferable file that populates your connection information within Aku Studio. Okay, so I had a supplemental slide with a little more details on that, but I don’t want to overcomplicate things. Let’s follow this agenda and take a look at how easy it is to install and connect. Aqua Data Studio okay, so let me switch over to my test environment.

Download Aqua Data Studio

Again, just introducing the Parent page. There’s a green box where you can download Aqua Data studio from here. Or if you’d like more information about Aqua Data studio, here’s the product page that has some summary information and then links and screenshots and more details. Here’s a list of all the databases that we connect to and how it installs so that’s available for you to visit. Here I’ve set up some other tabs maybe to talk through as well. Click on the start for free, and then you’ll be prompted to populate just some information about who you are. This can be remembered, so you have to populate each time. Ultimately you’ll choose which executable you’d like to download and then where you’re either saving that or running Oct on the fly. So this should be pretty straightforward. Again, a lot of effort and development has gone into this over the years.

And so this really works well. It’s, as it says, a tool that downloads and installs within seconds. We’ll dive into how to connect and use the product. This is all documented as well, right? Just from the product page, you can see documentation here. All of these steps are documented very well. If you’re curious about having more detailed information on these steps, it’s very easily found within the Aqua Data Studio documentation. Okay, so again, I have a couple of areas that I’ve set up for this presentation. So I’ve downloaded the product. Here’s the executable, but I’ll kick off. Here I have a directory where I have a few files that I’ll work with after the install. Some saved connection files that we’ll take a look at. Let’s start by just running the executable. If I just double click on this executable that I downloaded, that will step me through the install wizard.

Again, some of the screenshots that were in the PowerPoint will be duplicated right here. I’ll accept the license agreement here in terms of evaluation or some of the details there, but pretty standard. Are you updating an existing installation or installing in a new directory? You might expect that type of option. We showed that on the screenshot within the PowerPoint as well. I’ll choose to install a new directory for this example. Again, where you’re installing, you have choices there. You could choose a different directory path, but there’s the directory name, aquidade studio, and the version of the product. Again, some naming conventions in terms of your Start menu, your desktop icon, and within a few seconds, the product installs, and then you can open it up and dive in. So, I mean, how easy is that? That’s really one of the strengths of Aqua Dude Studio, that, hopefully you’d expect in a 15 year product, right?

Very easy to download, easy to install. Let me dive in and start using the product to perform my job responsibilities. Okay, so I’ll click finish there, and then here’s an example of the icons I’ll just keep it here on the left in case they don’t maximize the screen here. Double click on the Aqua Data Studio icon and the product will open up. You’ll see the splash screen as it’s opening. And then I have two existing connections. Those wouldn’t exist until you first open up the tool, but otherwise really a clean install here. This would be similar to what your environment would look like as well. You won’t have any databases listed until you connect. This would probably be the starting screen. I did tie in with the PowerPoint slides to help licensing. Help License would open up and then either choose Evaluation or the Activation icon there that we showed in the PowerPoint.

Connect to a Database in Aqua Data Studio

Okay, so to connect to a database, it’s the very first icon, right? If you hover over, you’ll see the Register Server or Server Register Server, or rightclick on local database servers and Register Server. Okay, so different ways as you become familiar with the product, whatever is Quickest for you. Server Register Server now shows that alphabetical list of where we can connect, right? And so this list continues to grow. We have different versions of these platforms. There’s probably even more than the list here. If you separated each version of different database platforms, for example, but as you choose a different database server, notice the text boxes would change, right? This is where there’s been a lot of effort development into the product. Here I could choose say, Amazon Redshift or say DB Two, or say SQL Server. Notice what is needed and the requirements for that connection.

The development is already there for you, so you don’t have to figure out what is needed for each platform, it’s listed here for you. There’s different ways of cloning these connections that we’ll talk about here in a moment. You can explore this list and see how some of this information varies. Maybe for the sake of this presentation, let’s add Oracle connection. I have a couple of SQL Server connections, so ultimately you could explore right now with where you’re currently connected to. For this example, let me click on Server, Register Server and choose, say, an Oracle connection. You’d need some of this information ahead of time. Let me just start to populate this database connection window within Aqua Data Studio. Call this my Oracle connection. You have just a customization here in terms of what type of box is that? Is that a development or test box?

Really just a way for you to recognize here’s a color coding that you could choose. Again, just flexible customizations to help you move more productively. A visual representation might help you keep track of different environments you’re in. So that’s customizable here. I’ll choose Red for Oracle maybe, and then choose how you’re connecting. You’d have either an existing user provided to you by your DBA. Hopefully you’d know some of the server information about where that resides. This is where you might need to an IP address or some more detailed information about the servers that you’re connecting to. In this case, I’ll populate what Oracle needs. Here one of the Oracle specifics of Oracle. And then I can test that, right? So test that connection. Green is good, obviously, right? Here it’s saying, okay, connections, accepting the socket connections, your user password is correct. If this was incorrect, you’d see a specific message there, right?

Here if I say I had an incorrect password and saying, okay, the connection is open, but user password didn’t like that, so it really saves you time. Okay, what is needed here? What do I need to figure out in terms of what’s needed for this connection? Of course, the ability to save that and have that step saved for you where you don’t have to step through this connection window each time. So let me test that again. Okay, good. Green checkboxes, close that. And now I can save this. Now that’s been added to my list of servers where I’ve previously connected. I have different ways of grouping and starting to build this server connection list. Okay, so we started with some SQL Server connections I already had. I stepped into an example of connecting to Oracle. Let’s maybe look at how to connect to my Excel data, right?

Here if I choose Microsoft Excel, notice it doesn’t have a say, user password. It’s just asking for the directory path. What folder is holding your Excel files? Right? What is the map drive that is the location of these Excel files. So, again, you’d name this connection here. Maybe I’ll just call this Excel, for example. Again, these are just customizations here. Maybe I’ll give this green for Excel. Okay, so just flexibility, customizations you can make for your own world. Here in this case, it’s asking, okay, where is the path for those Excel files? Here I could just point to a local folder or if there’s a map drive, or maybe I work with colleagues. You have flexibility here in terms of thinking of how you might leverage this area to connect to, say, a shared Excel environment. Maybe test that just to make sure everything’s working okay with Microsoft.

Query Analyzer

And then say, save that. And now my Excel path is listed. If I was to say, explore these environments, right? Here’s my Oracle environment where I can drill into schemas and see my schemas and then objects, or in this case, tables under a schema. If I was in SQL Server, I could drill into, say, my databases and then see my tables under databases. So for excel I drill into Excel. It’s listed under databases, but there’s this folder that I created for this demonstration where I have some Excel data. It’s just reading those Excel files from that directory. I have the ability to explore or navigate that data as though it’s a database table, right? Okay, so the other core window that you’ll start with is the query analyzer. That’s maybe beyond the scope of what we’re talking about today. But, if I was to say, open up a query analyzer, or if I right click and say, open up a query analyzer against these different environments, then I could just start, say, typing or running select against, say, that specific spreadsheet or data set, right?

SQL Server Environments

Here if I was in, say, my SQL Server environment, I could right click, open up a query analyzer, and then I have my connection to, say, a SQL Server environment, right? Or if I was in Oracle, I could right click, open up a query analyzer against Oracle. Now I see some of those color coded differences there, right? Or if I just started typing away here, you can start moving forward in terms of working with the tablet and some of the pop up windows that you’d expect to be looking for in your local database environments. Okay, so don’t want to get too deep in terms of how to use the product. We’ll probably have other videos there. Hopefully this allows you to jump start, maybe dive in, start using the product in terms of connecting to different environments by the Server Register Server very first icon or the Server Register Server menu.

Of an advanced area in terms of connecting that I thought would be helpful here. But didn’t want to confuse anybody. That these connections are saved as a connection file. And that’s a shareable file to populate. Say. Another install. Aqua Data Studio. Or perhaps populate these connection areas for another user where they would just need to then enter. Say. Their user and password. Right? Okay, so let me just be a little more specific there. Here I have a few different Explorer folders open. One of them is a path to my connections folder. Okay? Aqua Data Studio installs into a user directory. There’s the Data Studio folder and the connections folder right here you can even see. I’m looking at this connections folder and see how this matches my existing connections. So I see. That Excel connection. I just created those existing SQL Server connections. There’s an Oracle connection, right?

Here’s what I wanted to show you. You could share this connection file, right? Here’s this installation directory where I have some saved connection files, right? So let me copy this. MySQL connection file just going to right click, say, copy. Now paste that here into Aqua Data Studio connections file. Right click paste. Now I’ll refresh this connection list within Aqua Data studio. See, that connection populated for me so I can hit refresh this list. Now there’s, that MySQL connection file that I just copied and pasted. Right. Okay, so maybe that was advanced in terms of that last step. I think you can pause and rewind this to see more details on that. This is important when you’re dealing with a lot of connections. The ability to just quickly copy this conn file into an existing Data Studio connections directory really is a time saver and allows collaboration for a large number of users of Aqua Data Studio.

Okay, so again, just to maybe switch back to what we covered here, so we introduced where to download the product it installs on different operating systems. There’s a quick activation step and then very easy to dive in and connect to either a database, either or an Excel spreadsheet, or even share that connection file. Again, ultimately, a robust environment will have a history of connections. You can have server groups and really just, again, a way for you to be as productive as possible. Meaning saving time saving clicks through a database tool or productivity software for different job responsibilities. Right. Aqua Data Studio is the type of product that is used by developers, DBAs analysts, really, any It professional that needs to connect to a database and work with data. Okay, thanks for joining. Look for more video presentations on how to become more efficient aqua Data Studio.