Forum Discussion
Automatic import of new databases
You can see all the databases on the server, either by right clicking on the server in the Get Data pop-up window (don't choose one database or table) and select "Transform Data". Or you can modify/remove the navigation step to get to same view. Once there you can add a column to extract the table from each database and append. Repeat for the other tables to combine. Example with sql server below.
Pat
Yes, all databases in the same dataset. However, every time a new database is created do I have to add its tables manually?
You can see all the databases on the server, either by right clicking on the server in the Get Data pop-up window (don't choose one database or table) and select "Transform Data". Or you can modify/remove the navigation step to get to same view. Once there you can add a column to extract the table from each database and append. Repeat for the other tables to combine. Example with sql server below.
Pat