Static Data Source
The Static Data Source provider stores the Data for the Data source in the Data Sync project file. This can be used to capture a snapshot of a Data source and then use this to synchronise with other targets. You might use this if you are preparing test data and these project(s) can be used to initialise a target system to a know state.
To create a Static Data source it's best to start with your source data (what you want in the Static DataSource provider) as your Source (DataSource A). Then open the Tools menu and select Create Static Datasource. This will copy the column headers in the Schema Map into the schema for the Static Data Source.
Next click Run Compare and then Synchronise to sync your data, and load it into the static data source.
Finally click onto the Swap Sides button to swap the Data sources around so that the static data source is now the source (Datasource A).
You can then click onto the Connect button in the target window to change the target connection.
Columns
The Schema Columns of the Static Data Source. Click onto the ellipsis to open the column collection editor and change the column properties such as the name or data type.
Data
The Data is stored in the Data Sync Project file under the Project\DataSource[@Direction='source']\InitializationData node in .NET DataSet format you can edit the project file directly in a text editor to modify the data if necessary.
Since the Data is in the Project file, making data changes at runtime requires the project to be saved. Therefore this is not something that can be done via Ouvvi or the RunTool.