Aquafold
Request Demo

MacOS IDE

Hello everyone and welcome to this Aqua Data  Studio using macOS webinar. I’m your host Anil Mahadev and today we’ll be walking you through the various methods of navigating the user interface as well as working with Aqua Data  Studio on the Mac platform. A couple of housekeeping takes here at the top right hand corner of your GoToWebinar control panel you will see a Q and a box where you can type in the questions and then if you’re having any questions after the fact, we will take them. This webinar is going to be less than 20 minutes so we’ll leave some time over for some questions. Without further ado, I just would like to get a show of hands if you’re able to see my screen please, and if you can hear me clearly. Okay, good. Awesome. So now let’s go ahead and proceed.

Aqua Data Studio

First and foremost, Aqua Data Studio is the leading database application administration and developer platform here from Idera. We pride ourselves in benefiting the end user community by providing both a mixture of database administration, basic data modeling, basic database analysis or business analysis as it were for the business technologist. 

MacOS

What we have here is an environment that you can see is on a Mac platform. Now to showcase today’s demonstration, I’ve done a couple of things. One is I have gone ahead and one is I’ve gone ahead and installed a docker container in order to showcase the databases here at hand. Plus I’ve also gone ahead and connected to a Linux operating system to target the database as well. Let me take a look at the questions. Yes Stacy, the recording will be sent and we will answer all of this questions here in a bit. Here in terms of leveraging how we can go ahead and start connecting, the very first thing you will do is visit the website and go ahead and download the Mac version and extract it and add it to your applications folder.

Next what we’ll do is once we launch it, you will be given an option to go ahead and choose the evaluation. We can go ahead and choose the evaluation section and what we’ll do is now show you how we can register a bunch of options here. I noticed one of the first questions was how do we do the generic ODBC and JDBC? Well for macOS there’s a JDBC option and for generic ODBC I believe there must be an ODBC driver. Most of the clients that we have seen, they usually use bridges where they would actually do a typical ODBC bridge and some of them are mostly using JDBC. 

SQL Server

For the purposes of this demonstration I’ll be using Microsoft SQL Server and here I can actually go ahead and register a new connection. Right now I’m using a docker container and connection to a Linux operating system that contains a list of databases from this.

Mac Firewall

Here you can see if I go into the server properties, I can see what I have been connected to and if I go and test the connection, I have a successful connection. One of the caveats to doing this will be to actually going ahead and enabling a firewall since MacOS does not support native installation of SQL Server. Here in a container, I’m using a docker container and here you can see I created a database called ADW Container. Here you have all the list of all the system views and tables that you can access. On the left hand side, as you can see, the UI is just the same. We want to make sure that we provide a unified customer experience for the folks on the back platform as well. Here if you look, if you go to the servers, you will find that you can go and connect to the servers.

Linux OS

Here I’m going ahead and connecting to a Oracle Linux OS and this gives me all the information about that particular OS, what CPU it’s being handling, what’s the memories, the disk and the file system that we’re working with. You have a lot of options here. Next what we have is let us explore one of the databases. Here on the left hand side is your Database Explorer and then on the right hand side is your Query Analyzer where you can actually go ahead and write queries. On the right bottom half is you have the Result set window where you can generate result sets to a multitude of areas. If you happen to be using Ads on Windows and then you just recently transitioned to a Mac, I’m using macOS Big Sur. That’s the one that I’ve installed, ads 22 version. That’s where you’re seeing the demo from today.

Query Analyzer

Here if I go to explore some of the tables, I will do just exactly as if I would go ahead and do it in Windows. Here if you choose Query Analyzer and I can open up a new Query Analyzer, I can even go ahead and do this, select the top 1000 rows, execute and here I can instantiate a new visual analytics workbook and I can drag and drop some of these rows and columns. From there what I can do is I can highlight the customer ID to be in color and I’ll do the phone number in color as well. That will also give me of leeway. Plus with all the other options as well, we can choose different shapes. Here you can see I have different shapes and you saw that I’ve broken down the email address and I can even show a filter. I can filter based on this, or I can even search.

If I do not want all of these, just want to search a couple of these and have them, I can have this here in this way. Again, no loss of functionality or anything, you can do it just as you were doing it before, you can also go ahead and clear the worksheet and there you go and start from scratch. 

Database Charting

Next, what I’m going to be showing you is the ability for you to actually go ahead and look at some of the charting capabilities that you require. Here, look at all of these, you need a series of charting options and here you can choose whichever you like here based on that you can even have a 2D or a 3D based chart, you can have all of these here as well. Now, let’s say for example, if you wanted to view the database properties you can actually go ahead and rightclick and look at database properties.

This should instantiate the same windows and it’s just going to show you the path where that particular database resides with the MDF and the LDF files. Here you can also go ahead and look at the options of what compatibility level it is, all that good stuff. Here we provide you with a space usage. Again you can choose however it is and look at all of that and once that is done you can also go into any of the tables, you can rightclick and you can choose Alter table and that’s going to go ahead and show you all the different varieties of altering this here as well. Next let’s talk about how we can go ahead and look at some of the other functionality. 

Query Builder

Let’s go ahead and go to the query builder and click New. Now I’ll go ahead and click on Connect server, go to my SQL server here, connect to my LTE database and slowly I can go in here and I can highlight these and just say add to diagram.

Now if I wanted to do a join, all I have to do is drag and drop here, select this and highlight it here. I can even do a group by. I can create a sequel expression and I can say group by customer ID or name style. I can do any of those. I also have the ability to drag and drop views as well. If I drag and drop the views, I can choose all of that and I can just highlight these. Now what I can do is I can copy this, save it, and then if I wanted to, I can just go ahead and execute. If it meets the criteria it will work, if not it’ll just give you an empty result set so that’s how easy it is to go ahead and work with the query builder here. Next, what we can do is show you also some of the capabilities within the IntelliSense.

Here you can just hit a tab or an enter and then I’ll just say a comma customer C where a dot address ID is equal to C dot. If there’s a customer ID I’ll just put it there. You can actually go ahead and do that and get the results at here as well. Next, what you can do is you can actually go ahead and say if you want to do add a expand or collapse for various region you can do that. You can collapse this and add this as part of a region and then here you have the other one as well. That also makes the beautification of code and the maintenance of code really good and formatting wise. Of course you do support the comments here as well. Here you can just go ahead and right click and you can say toggle statement comment like this.

GitHub Repository

Now it’s gone ahead and added a statement comment here for you. Now what makes ADS unique on the Mac platform is the following one of the things is that here I’m having a connection to a GitHub local repository that I have so I can technically go ahead and connect this to GitHub. You can also go ahead and have this in the file system. Typically you can mount the directory as well and then you can also go into Fluid Shell and go from there. You can go right here and go to the directory. This brings us to the Fluid Shell component which is also there as well. To put things into perspective, you really are getting the best of both worlds, especially if you’re transitioning onto a Mac to keep your Ads skills in check and also up to date as well as work with all of the multitude functionality that the Mac platform has to offer.

Scripting

Next we go under the project section where you can actually go and set up a bunch of aqua scripts. Here again I just say demo and then I can actually go ahead and see if I can insert the Aquascript that I’m looking for here. I also have the ability to look at, let’s say I wanted to automate something so if I wanted to introduce an insert statement here I can actually go in there and automate it. I can also go ahead and introduce columns if I’m going into, let’s say here. If I just come back in the query builder, let’s introduce a select and there you go and it goes and does from and then you can then choose from which table it’s going to go ahead and bring it to. If I do a sales lt customer where customer ID is ABC or something, you can go ahead and add that.

You can also go ahead and choose what is the execution plan. Let me go ahead and get that here. So let me uncommon this here. What I can do is I can actually go into and just say execute, explain and here I have my execution plan that is being displayed here as well. I can also do explain diagram now this brings up a really cool diagram interface where you can actually go ahead and leverage this to your advantage. Not a lot of tools have gotten this. Especially from a cross platform perspective, this is where ads shines and that’s where you can do a lot of this stuff.

ER Data Modeler

Next, what I wanted to show you is our Er modeler. Here if I wanted to go and right click on any of the databases, you can go to my tools section, and here I can just choose Er diagram generator, and here I can choose the appropriate schema. It’ll go ahead and bring all of those. And there you go. Here’s our schema then you can show or hide any of those areas that you do not want to have and that’s it. You can just have just the entity with the columns, just the basic primary keys, all that good stuff. I can save this. From here, you can actually go ahead and also go ahead and print it. You can print it to any of the types that you want next with the ads on Mac.

SSH

The other important thing is, whenever you’re registering a server group or any of that stuff, you can also go ahead and register an SSH server. For example here, for example, if I were to get that information from the server so if I go here and navigate to the Oracle Linux, and then if I say Connect, and if I go into Open, let me open it here.

It straight away takes me to my Linux environment that I have here. I could come in here, write my shell scripts, everything. I can just say, technically I can just say I do echo from Linux using Ads. I can get all of this here as well. There’s a lot of other functionality that are built into the tool and then I can always go ahead and make changes. If I hit exit the SSH session is now out. The next thing we have is our fluid shell which is within the Mac operating system that you can go ahead and execute other examples. If I say macOS using Ads there you go, all of this is there. Now if you wanted to go ahead and look at some of the commands you can just do a slash help and it gives you all of the list of all of these properties that you have.

Generate SSH Keys

One of the other key options is that you can always go ahead and kickstart your visual analytics there and you also have the ability to look at some comparison tools here as well. You can also generate your SSH keys. If you wanted to generate your public and private key, you can go ahead and do so. You can also go ahead and save your private key here onto your machine and have that being used for any kind of connectivity that you would like. Let’s see now, what else? 

Data Storage

Yes, and of course, just like the Windows counterpart, we do have the ability to go into the Storage Manager. Let’s go into the instance Manager about here. So, if I wanted to go into this container, I’ll click on this. It gives me all the information about the SQL Server container. Now, if I wanted to do the same thing for my Linux mSQL, I can go into my DBA tools and go to Instance Manager here, too.

Here you can see the key differences. Both are of the same because they’re both based on the 2019 OS. Last but not least, you have the ability to go into your DBA tools and look at the Storage Manager. There we go. It gives you this nice, neat graph and grid that you can see how much has been reserved, how much is there, where the data files are located, anything with regard to the objects. You can choose the database here. If you want to look at the type and the table, it goes and gets you all of this here as well. So, with that, I would like to come to the end of my demonstration. This was just a very brief overview. If you would like more to see examples of this, please do leave a note in the comments and the feedback. When you get this webinar recording, we’re open to ideas, and we would love to show you more about how we do all of these wonderful activities in Aqua Data  Studio.

With that, let me just go ahead and stop sharing my screen, and then I’ll go ahead and take the questions. 

Connect to Database

For now, what is the best way to connect to a database that’s not in the standard list? A lot of functionality is not available via ODBC or JDBC. Well, we do ship with the standard drivers, Robert, and then it does have the ability to connect to those databases. You just have to get that as well. Now, with regard to the Mac version that works on the M One, I have tried personally evaluating it via the Amazon service. There, I did get it to work, but officially, it’s still on the roadmap. If you have an M One processor today, feel free to download the product and let us know and one of us will be able to help you out if need be.