How to export data from the dimensional viewer in Toad Data Point

This video shows how to export or publish data from the dimensional viewer in Toad Data Point. Learn about the various ways to export data to a file format of choice, how to quickly drop your aggregated data into Excel features like pivot table, and how to publish data to have Toad Intelligence Central.

Hello, folks. My name is Robert Pound. And I am a product technologist at Quest. This video shows how data from the dimensional viewer in Toad Data Point can be exported or published for further exploration. It is assumed for this video that you are familiar with the dimensional viewer and have an active connection to Toad Intelligence Central server.
As we can see on-screen, I have a saved dimensional viewer, where we have explored data from a particular table. So looking at these individual tables, we may want to export all of these, so that we can further explore them. For this, we can come to the bottom and choose Export All. What this does is open up a window that gives you, in this case, just the Excel option. And we will see why in a second.
But we can choose the location of the file. So let's go ahead and rename this Dimensional Toad Export. And you can choose to append a date, time if you choose. You can also overwrite the file.
So for each one of the tables in the dimensional viewer, you have a tab in Excel. And that's why it's only export in Excel if you want to export all the data. So for each one of these, you can look at information about each one of these tabs. You can sort through it.
For this particular one, we can see a warning that says we only have 31 characters in Excel. So we can rename this. And let's go ahead and just cut out a portion of it-- created at and then underscore row count, count. So that way we don't get the name of the tab truncated. And if we were not overwriting, there would be options here in the grayed out area for appending, if we had run this previously-- so where we want to append the data to, et cetera.
And then you have options for the header file as well. I'm going to go ahead and export this. And it's exported it out to the file that we chose. I'm going to go ahead and open it from the window.
And we can see we've exported the data in each individual tab. And this tab has been renamed. So now we have our data in an Excel format, which is good. We can continue on with our exploration.
But perhaps we want to export just a single table. So for that, we can right-click in a table. So we have several options. First, we can choose Export and the Export Wizard. And this gives you the most options for your output.
So as you can see, we have CSV, Fixed Width, XML, Excel, SharePoint, et cetera. I'm going to use CSV. And I'm going to choose the default options. But you have options as far as the output of the data itself.
And you have your typical Select Columns, et cetera. I won't go into the details because that's covered in another video on the Export Wizard. But, again, we can choose the location of the file itself. And we could choose to export other objects at this point. I'm going to go ahead and finish.
And, again, we've exported this single table. And it's using Excel to open it. But it is a Comma Separated Value file.
We also have the option to export using the Quick Export. So File, it gives you the option to export to Excel, CSV, and HTML. And this basically will just export with a date time stamp. So you don't get to name the file in this case. And it just saves it to the default file location.
You also have the ability to use Quick Export to export to instances of Excel. So this, if I had Excel already open, it would, at the active cell, it would open up a new instance, et cetera. You can also choose either a chart or a pivot table. I'll real quick open it to a pivot table. And this will allow me to, of course, start dropping in values into my pivot table and continue my exploration of the data.
And since this is opening up an instance, it's not saved automatically. It's just opened up in a book 1 Excel workbook. So if I don't save changes, it will be gone.
Now let's look at publishing the data. So if I want to publish all the data in this dimensional viewer, like I did with the export, I can choose Publish Data. And this, obviously, only applies if you have Toad Data Point Pro and a connection to a Toad Intelligence Central server. But in this case, I am connecting out to my Toad Intelligence Central server.
I can do the typical data set sharing options, as far as choosing folders, connections, et cetera. The one unique value is the Publish Data option. So here you're publishing three specific data sets. So if you wanted to choose just two of them, you could obviously exclude one.
And you can rename the value of the data set here. I'm going to leave these default. But this is where you actually affect the names and descriptions of each one of the individual data sets. And as I have ran this demo in the past, it's telling me that I need to overwrite if I want to publish these. And I can go ahead and publish them now.
And it's publishing all the data sets out to Toad Intelligence Central server. These are individual data sets that have been published. If I wanted to publish just one data set, again, I have the option to right-click and choose Send To. And now I can simply publish the container.
So this is looking at a single table. And now I can name it whatever I want, just like I did in the past-- let's demo123. And Overwrite Existing, I can choose my share options, and Publish. And it's also been published.
So, hopefully, this helped shed some light on how you can export and publish your data from a dimensional viewer so that you can continue your exploration of the data. For more information on this product, visit www.quest.com/products/toad-data-point. You can also check out the community-driven innovation going on at www.toadworld.com. Thank you and have a great day.

In this video you will learn about the database diagrammer tool in Toad Data Point, the solution from Quest that lets you streamline data access, preparation and provisioning to improve productivity of your analyst teams.

In this video you will learn about the profiler tool in Toad Data Point, the solution from Quest that lets you streamline data access, preparation and provisioning to improve productivity of your analyst teams.

In this video, see an overview of how to build a query in the Query Builder tool in Toad Data Point. Some topics include: an overview of the tool bar, how to interact with objects, how to create and analyze joins, how to filter and aggregate queries, and how to view and execute queries.