iShare Studio where Data Share database is your SDW
...
- Open Studio
- Right click on the Data Share Connections node and select Add Datasource. Please follow the instructions for Adding a new Datasource in the on-line Help for the type of datasource you wish to connect to.
- Once you have created the Data Share Connection you can either right click on it and select Synchronise to populate the SDW or, if you want to schedule this, create a Workflow Job and Task. This copies the data to the public schema in your SDW.
- You now need to move this to a different schema within your SDW.
- Check that your have a Workflow Connection to your SDW and if not create one.
Create a Stored Procedure Task to drop the table in the new schema using the at_wkf_executecmd function function (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter) with the cmdtoexecute parameter similar to the following:
Code Block DROP TABLE IF EXISTS schema_name.table_name;
Create another Stored Procedure Task to move the table from the public to the new schema. This is done using the at_sdw_move_nonspatial_table function e.g.
iShare Studio where Data Share database is not your SDW
...