Toad Data Point Import Wizard

Hello, my name is Robert Pound and I'm a Product Technologist request. In this video, you will see how to pull data into your data sources using the Import Wizard. So there are different ways to use the Import Wizard. I'm going to use the ribbon bar. So the first thing you need to know is whatever is currently in focus is where you're going to be importing. So depending on what you currently have selected, that's where we're going to import. So I'm going to go ahead and choose the SQL server that I have connected. And here at the ribbon bar, I'm going to choose the dropdown list and then choose Import wizard. And after the Welcome page, I'll click Next, and we're presented with different options for importing data into, in this case, the SQL server. So we have our file sources and then our data sources. So first, let me go ahead and click on Add File. So once you locate the source of the file that you want to pull in, and you can see from the dropdown list there are several different file formats that we can pull from. I'm going to go ahead and click Open. Now, at this point, it's going to pull the data in and it's going to allow me to first of all, choose the data source. Since this is an Excel file, I have different tabs to choose from. So I'm going to just choose the Accounts tab. And now we can limit the data depending on what we want to pull in. I'm going to choose the defaults, and it's going to give me a sample of the data. And at this point, I can remove columns if I choose. And I can choose to load this data into an existing table, or I can choose to create a single new table. And go ahead and create a new table. We're going to drop it into the Toad database. We'll call this count 1. And I can choose a schema if I want. I'm going to go ahead and leave the default. Toad Data Point does its best estimate of what is needed for each one of the columns, but if you know, for instance, that the account name will probably need a NVARCHAR of 100, then you can modify that. I'm going to go ahead and leave the defaults, and go and click Next. And now we're ready to import on that job. Let me go ahead and add one more real quick, this time from a query. I'm going to import one more time. And at this point, we need to select our source, so if I was pulling from SQL, I would leave it on SQL. In this case, I'm using a SQL file from the sample database, and I'm going to go ahead and actually open the file. And order item, and it's going to pull the query in. And if I want to preview it to make sure that it's actually pulling data, I can. So let me go ahead and click Next. And again, I'm going to go ahead and pull this into the new table into the Toad database. We'll call this Word, and Next. Now I have my two imports that I want to accomplish. Let me go ahead and click Next at this point. I could edit or remove jobs or tasks as I see fit, but I'm going to go ahead and click Next. And I have the option not only to import the data now, I can also save this action as a template to be used in automation later. I could also send this to automation directly so that I can begin an automation task, and then I'm going to go ahead and do an import now. And it lets me know once it's complete how many rows were imported, and let me go ahead and click OK. And if we open up the Toad database tables, we can see that our order 1 account 1 has been created. So that's all there is to it. Hopefully this helps you out in understanding a little bit more about how to manipulate data in Toad Data Point, how to use the Import Wizard. For more information on this or other topics, you can check out the Help file, which has all the help content as well as tutorials to help get you started. And also, check out the community driven innovation going on at www.toadworld.com. For more information on this product, you can visit www.quest.com/products/toad-data-point. Thank you, and have a tremendous day.