How to publish projects in Toad Data Point

Hello. My name is Peter Evans. And I'd like to talk to you today about Toad Data Point and publishing projects. As you know, in Toad Data Point, you've long been able to save a number of files to a project. Here, we have our Project Manager. We'll create a new project. We'll, say, call this Test Project. And that project will now become part of our Project Manager. I have a number of files open here in Toad Data Point. For instance, I've got a SQL editor here. I'm going to add that to the project. I've got a couple of automation tests. And again, I'm going to add these to the project. A Transform and Cleanse-- and we'll add this to the project. A second automation script-- we'll add this to the project. And then lastly, a third automation script-- and we'll add this to the project. If I now go to my project file, you can actually see that I have all of these built. So within my project, these are saved within my normal area. I've got my increment. And you can see by my tool tip that they've saved to my C, Users, App Data, Roaming Quest Software file area. This is very good if you want to be able to keep these as a project on your local machine. But to enable you to travel, enable you to secure this data more rationally, and also be able to share this data through our new Toad Intelligence Central Collaboration feature, what we've done is enabled you to actually publish this project file out to Toad Intelligence Central. So here, I can go very quickly to my Publish All Projects. If I hit the button, I'll see that I've got my selection up. I can select my Test Project. I publish by selecting the Publish button. And this brings up my Publish to Intelligence Central dialogue. This allows me to select a server. Here, I'm selecting my localhost because I'm publishing to the machine on my normal server. I can choose a folder. So I've got no folder assigned here. I might want to actually create a folder for this published file. So we'll go call it Project and Test. And we'll go OK. And now you can see my destination folder is Project Test. The publish type is grayed out because obviously, it's only that type of file. It's a Project Manager file. And the name has been copied across from the actual name within our project area here. I can then decide how I want to share this data-- if I want to keep it private so that I'm just using it with myself, or I can choose to share the data with any user or share the data with selected users. Here, I'll just share the data with any user. And this means that any user can see this published file and see the objects within it and actually work with that data. This enables you to build confidence within your team, and also enables you to enable younger team members or inexperienced team members to learn how you built a project and how you've worked with it. So you're closing that skills gap. And you're improving your mentoring as you go forward. I'll now hit the Publish button. And very quickly, you can see down in the right-hand side that we're actually publishing this data. And it's actually coming through. And here, we have the data published. I can now go OK. And if I go to my area and go to my local Intelligence Central in localhost, if I double-click on the connection and go to my Object Explorer, we can actually see that within my area, I now have a Project Test. I have my automation scripts. I have my query. And I have my transformation. I hope this has helped you to understand how Project Manager and Project Manager files can be published to Toad Intelligence Central, enabling you to be more proactive with your data and how you save your data.