Example 1: Publishing a catalog that contains materials from a database table
You want to publish all materials in your database that have status 'Released', as a single catalog.
How is the data organized in Granta MI?
In this example, all the required materials belong to the same database table, Materials. (See Example 2 if you need to publish materials from two or more database tables.) The records have an attribute Released with possible values 'Yes' or 'No'. This can be used to filter the materials included in the catalog.
How many synchronization jobs?
To publish as a single catalog, you need to create a single synchronization job: 'All released materials'.
Within each synchronization job, how do I define searches to find the materials I want?
The materials come from a single database table, so you only need to define searches on that table (Materials). In this case, one search is enough, because you only need to consider one combination of attribute values (Released = 'Yes').
Hence, you can construct the synchronization job by defining a single search on the Materials table, with a single search criterion: Released = 'Yes'.