You can create a Remote Context Service (RCS) connection to any SQL data source. You will require ODBC access (with appropriate read-level permissions).
Each object in the system will require an identifier (string, GUID, Int) that is consistent and unique amongst its object type (KPI, Group, Trend, Etc.) which will act as the mapping between the foreign system and Visual KPI (see links to reference tables below). Note: if this ID changes in the foreign system, a new object will be created in Visual KPI and the old object will be deleted.
Every definition query (KPI, Group, Chart, Etc.) must return a column called “metaid” with this unique value.
For a complete listing of supported attributes for each RCS (including SQL and others), please see the following articles:
- Groups Attributes & Keywords Reference Table
- KPIs Attributes & Keywords Reference Table
- Charts Attributes & Keywords Reference Table
- Tables Attributes & Keywords Reference Table
Transpara is happy to assist you with your RCS queries. Just contact support at firstname.lastname@example.org for assistance.