Example 3: Materials from one database table, published as multiple catalogs
You want to publish materials in your database that have status 'Released', but as separate catalogs, one per material type (Polymer, Metal, and so on).
How is the data organized in Granta MI?
As in Example 1: Publishing a catalog that contains materials from a database table, all the required materials belong to the same database table, Materials. The records have an attribute Released with possible values 'Yes' or 'No', and an attribute Material type with values such as 'Polymer' and 'Metal'. You need to use both of these attributes to identify the required materials for each catalog.
How many synchronization jobs?
To publish as separate catalogs, you need to create a synchronization job for each one.
Within each synchronization job, how do I define searches to find the materials I want?
For the catalog 'All released polymers', the materials are from a single database table (Materials) and must satisfy two conditions: Released = 'Yes', and Material type = 'Polymer'.
Hence, you can construct the synchronization job by defining a single search on the Material table with two search criteria: Released = 'Yes', and Material type = 'Polymer'.
The synchronization jobs for the other catalogs ('All released metals', etc) follow the same pattern.