The process of defining a new data source for mapping into Safyr consists broadly of 3 steps:
- Research work to identify which tables store the required metadata
- Definition of a set of queries to extract metadata from the relevant tables
- Definition of mapping between these tables and the Safyr repository
Each package has its own features and challenges. However, the task of addressing a new package will take a competent analyst who has a familiarity with SQL and database concepts a matter of a few days to complete. Once the definition work is done, any other instance of that package will be addressable. It is Silwood Technology’s intention to offer a growing range of ‘generic’ package solutions, as usage of this feature grows. We have already used this approach to address Microsoft Dynamics CRM. Other packages are in development.
Please watch this space. Please contact us if you would like more information on this capability.