Data Generation will investigate a database table schema and offer the user some options about how to populate that column with data. Some of those options might include inserting some values at the minimum and maximum allowed values for the column as well some NULL values. Test Data Generation's entire purpose is to help the BI developer create a comprehensive, error free, and resilient business intelligence solution.
• Automatically generate valid data for a given schema
• Handle foreign key integrity for generated data
• Configurable volume of data
On the first page of the Data Generation page, you will first have to select your target tables. You can also if you choose to, select a shared data provider. This option is used to populate your tables with data. Click on the "Target Tables" icon to open the "Connect To Database" window.
After clicking the target tables icon, the "Connect to Database" box will pop up and you will be able to select your database.
After you have selected the SQL server and the target database click on "OK". The target tables section will display that it is loading the tables. Now that you have selected a database. The "Target Tables" area now prompts you to select one or more tables for which to generate data.
Clicking on that will bring up the Add Table window. From here you can check which tables you would like to be added. After you have done so you may click next. If you do not select all required tables related to others you have selected. The related tables will automatically be added for you.
If you are generating data for only one table, you do not need to select a data provider. However for multiple tables with foreign key relationships, you must select a provider in order to maintain referential integrity. To do so, click the icon that says "No data providers yet".
After selecting your provider, you will then need to name your connection and specify the database to be used. You will then be taken to the query entry page. Here you will enter the query to retrieve primary and foreign keys and any other columns that would be required. When done click on the test button to ensure that it retrieves the results and then click done to finish adding the provider.
To use the data provider you will double click the table that uses the selected column as its foreign key in the overview tab, doing so will open the table and display all the columns and their options.
Here you will click the edit link next to the column that needs to reference a column returned in the data provider query. Next to the Data Source drop down menu, click "Add New", then select the data provider that was added previously. Next to the Add New button is the Output drop down menu. From here select the column that was returned by the data provider that corresponds with the column in this table.
You can also edit the table options. These options include using existing data, removing all data before it is generated, and you can change the number of rows generated as well as the batch size.
When done configuring your tables and data provider, click the Generate Data button located at the top of the tab. (Note: This table must exist in the target database to generate data.) The activity monitor will open up and show your progress.