ICE for Eclipse is a companion product. Companion products are not included in the core functionality with Eclipse DMS, but are available at an additional cost through your Eclipse Salesperson. |
"For me to create some really great dashboards in ICE, I need SQL tables for my user-defined files in Eclipse."
In Release 8.7.7, Eclipse now provides the necessary tools for creating Eclipse user-defined schema mappings in your SQL Database Maintenance. You can now define SQL (structured-query language) data replication for your user-defined files, such as PROD.CLASS and CUST.CLASS. Whatever important business data you capture in these or other user-defined Eclipse files is then available in SQL for leveraging in your BAQs (business activity queries) and dashboards.
The eclipse_ud option from the SQL Database Maintenance window lets you select the user-defined file you want to manage:
You can then use the SQL Table Maintenance to define the attributes and data types.
SQL Column Maintenance gives you access to the individual columns so you can decide which you need to sync to the main database.
You may need to experiment with your user-defined file settings and attributes to make sure you are syncing all the data you require for your queries, but these tools make it far easier to manage the information you need to build your queries.
Enterprise Search lives within the ICE application. It is a separate “tool” that increases the attractiveness of ICE but has no extra cost. After installation, the system displays a URL for an “internal” web page where users can search against Eclipse data and, in some cases, open Solar or Eclipse Mobile based on the results. For example, they can open a Customer record in Customer Maintenance in Solar for the Customer ID.
For more information, see Creating User-Defined Tables for SQL Replication in the Application Maintenance documentation.