TriMin’s SQL Manager for IDF is a tool that evolved from a need to better manage SQL, especially for IDF development. This tool comes with features and functions to manage your existing or new SQL Views and indexes, and also includes predefined content in areas like sales, capacity, inventory, and planning that is already IDF Enabled and ready to use after installation.
The product comes with some base training. TriMin can also provide structured training for your development team and Business Analysts to support your own efforts in your own development.
Our development staff has used this tool internally for years. It has evolved to be a fully functional, stand-alone product that uses the native features of IDF to manage your development and critical business objects.
Allows you to export/import, generate, and promote your SQL to new environments easily
Comes with predefined content for many IDF areas as a foundation to build from
Can import your existing SQL views so they can be supported in the tool
Allows you to import future content development by TriMin into your IDF
Supports Views, Tables, Indexes, and Procedures
Provides additional edit checking and other features to ensure standardization
Business Needs:
Provides a better way to manage all my SQL that drives my ERP and business processes
Need a way to support promotion from test to production or a new environment
Would like to support revision control on my views and other SQL components
Would like predefined content for all areas of IDF so that it can be leveraged and evolve to my needs and wants
Allows you to define not only the SQL content but also supports labeling needs
Allows a “non-traditional” programmer like a Business Analyst to be self-sufficient in IDF building and promoting views in IDF. Can build views over existing tables or create new tables from this tool