Hi, everyone. Thanks for stopping by. We're going to talk about what Toad can offer for open source solutions and we're going to go through this presentation. If you guys have questions or anything, please feel free to ask either before or after.
So I thought I'd start-- it's late in the day, and so I thought we'd start with, OK, if you think you know Toad, if you've been using Toad forever-- everyone always comes up and says, I know Toad. These are three numbers associated with Toad, OK? Let's see if we can guess them.
One, 20. Twenty years experience. Toad has been out I think since '98. It's 20 years on the market, a piece of software that's essentially the same, it's just been building up over that time. It's pretty huge.
Fifty. Over 50,000 companies are purchasing and using Toad today.
And then the last number, one, it's kind of a cheat, because it's really one million. There's one million plus users. And that's not the freeware, right, that's the commercial product. So Toad is out there, being used widely. If you haven't heard of it, I'd be shocked, right, here at Oracle Open World.
But who uses Toad? So Toad helps DBAs, right? We should know that, right? I've got some quotes out here about how it simplifies complex databases, helps you automate, investigate, diagnose problems. This guy is very enthusiastic about Toad. He wrote quite a bit.
Help troubleshoot. Right? So we know that Toad helps DBAs.
Toad also helps developers. In fact, that's how it started. The acronym is a Tool for Oracle Application Development, right? So that's Toad.
So it helps developers as well. So I threw some things in here that Toad developers have said. Improving productivity, highly benefits the teams.
Toad also helps data professionals. So there are flavors of Toad-- and we'll talk about them-- that are really about query and analysis, so not the DBAs, not the developers, not your SQL gurus, but your standard person. So all your work that can be done manually, and Toad allows you to automate it.
Impact on our clinical trials. Analyze data more efficiently. OK? So it helps all of those people, right?
We're at Oracle Open World. We know Toad works with Oracle. But what else does Toad work with?
So you may not be aware, Toad actually has some flavor of solution for all of these different environments, OK? What we care about today, though, is open source. And so when I talk open source, what database platform am I actually talking about? So MySQL definitely. But not just MySQL, but Maria. At least as much as Maria is equal to MySQL, we focused on MySQL and where there's they are the same, right, before it branches, it'll support Maria.
We also have Postgres, both the community additions, as well as EDB's Advanced Server Postgres, so their commercial version of Postgres, which, if you don't know, supports PL SQL. So when you think about migrations a lot of folks think about the EDB version of Postgres, because you can import that database code directly over. And then also Amazon Redshift as well.
Why are we supporting open source? Why is it important for Toad to do that? Because it's a trend. More and more folks are moving to open source. So this is just from DB Engines-- this is actually a little old-- showing the trend of how their people are swapping out their commercial license for open source where they can.
Gartner has been predicting for years, and they did it again this year, that by 2020, to more than 70% of in-house applications will be developed against open source, right, and 50% of existing applications will migrate. So that's not too far away. Actually, these are very close to the same numbers that they estimated would happen this year. But it is happening fast, maybe not quite as fast as they thought.
So why is the open source so important? Why are people moving to it? That's a pretty obvious one.
In the same Gartner state of open source, they did a survey across all the respondees, tell us the number one reason why you're moving. Up to 80% cost savings. That wasn't one person, that was the average.
So the average folks were saving 80%, just by moving to the open source platform, in the next six to 12 months. That's 80% realized in that quick frame. So it's a very compelling thing to do. And the state of the databases are they're advanced and they can support the kind of scalability and the kind of enterprise applications that you have.
So how can Toad help with open source? So we actually have a set of solutions that are geared toward open source platforms that can help you. First, the very beginning, on the database modeling side, is your planning your databases. We've got Toad Data Modeler.
Toad Edge is a new Toad. Just was born last year. Helps with database development and database management, but specifically for open source.
Benchmark Factory, which has been a staple of the Toad platform for years, is database performance for open source as well. And then Toad Data Point is that analysis tool I talked about for data prep and query against all of the platforms we've talked about, including open source. OK?
So let's look at Toad Data Modeler first. Physical and logical data modeling tool, all right? So when you're thinking about moving, migrating commercial databases into open source systems, the first thing you have to think about is that modeling out of that new database, right? What's likely the first steps?
You want to capture a physical data model to represent all the schemas of record. You want to review those models, not to just lift and shift, but you want to optimize where you can, right? You're moving into a new platform, and there's things you're going to lose, but there's things you're going to gain. So you want to optimize where you can.
You want to actually do the conversion and convert those structures, and generate those DDL scripts and execute, right? So you want a tool to help you do this. This is not something you want to do manually.
Toad Edge for development and administration. It's a simplified tool for-- it supports both Mac and Windows. It's built on a completely new platform, and it supports MySQL and Postgres, right? So this is the same-- think of Toad for Oracle and how much you love it.
This is the Toad for your open source environment, right? You can write clean effective SQL. Perform dynamic schema change, right? So not just a static schema change, but you can actually change your change parameters, and look at the differences between schemas and get to see the changes on the fly.
You can work with JSON data, which is becoming more and more important with MySQL introduced in seven, right, even becoming more important in MySQL eight. And it's DevOps ready. So what I mean by that, it's built into the tool, and everything you need to take, like your schema changes, for example, and integrate those with Jenkins so that on every build, you're looking at your schema changes, generating schema change scripts, et cetera.
Benchmark Factory, another great stop on the way to migration. You want to know your database performance and code scalability testing. As a DBA, how confident are you, as you're moving your databases to a new platform, that they're performing correctly? You need to be able to see how their performance was and understand the scalability of the next platform you're moving to.
As you integrate your database change management in DevOps, how can you be sure you can meet your SLAs, right? As you're doing this constant deployment, how are you assuring you're meeting your SLAs. You need to make sure you're benchmark testing and doing performance testing as part of any continuous integration that you're doing. Right, continuous testing.
Benchmark supports all the industry standard benchmarks. You can conduct database workload, and capture, and replay, compare it with other systems. And think about this too, even if you're moving to cloud and you don't think performance testing is something you need, how do you know how you're going to scale up in the cloud, right? How do you know what you want to provision for yourself? Are you going to overspend or underspend? If you know your performance metrics before you move, you're going to choose the right solution for yourselves.
And it includes a REST API. Again, always keeping in mind DevOps. So whatever you're doing, as a step, want to integrate that into your continuous testing model. And then of course, you want to make sure that your goal-- or SLA based testing regimes are meaningful. OK.
And last is Toad Data Point. This, again, is our single tool. This tool has always been multi-platform. So you can go to Oracle, SQL Server, Excel, Access. We talked with folks today who are moving to Oracle Cloud application and they need to be able to get to a subject area, right, they don't have access to the back end database for data. You can get to that from data point. You can log in and see your Oracle subject areas and query that.
And so this is the single tool to connect to all of your data sources, including open source. You can not only query individual sources, you can compare across databases. So as you've done your replication, how do you know? What statistics do you have that everything performed well? Maybe the tool you're using is giving statistics. Wouldn't it be good to also have a tool on the outside, giving a third party analysis of, this is how the data looks between the two systems, right?
You can create complex SQL without being a SQL guru. I hate writing SQL. I just hate it. So I use the drag and drop tool as much as possible and then only go into SQL writing/editing when I have to. So this can take people who are very uncomfortable with SQL and make them very efficient and very productive against the data.
And then you can automate it all. So everything you do in the tool, you can also automate. So from like beginning to end, working with open source, Toad has a tool there for you.
OK. So what are your next steps? Because you're all excited now about Toad and open source.
So first, learning. We have two great website that have a ton of collateral out there for you to learn from. Quest.com, which is sort of like our mother website, has a on demand webcast we've done. We've got a Toad Agile Cookbook. We've got some DevOps stuff that covers open source.
And then we have ToadWorld.com. This is our community for Toad. This is really close to our products. And we've got videos, evaluation resources.
But what I think is the best way to learn is to try it out, right? Toad has great downloads. We've always made that a staple of what we do. So you can go to ToadWorld.com, you can download any of the products that I've talked about with full trials. And then if you need additional trials, you can always reach out to anybody at Toad, whether it's just the admin of that site or any of us here that you grab our card and we can extend your trials as well.
10:34
