NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The process for connecting external reporting tools is essentially the same for all tools. External tools connect to the {{IMSMANG}} relational database via an ODBC connection. Information managers establish this connection by installing the ODBC driver for PGSQL. When this is complete, information managers can connect any ODBC-compliant tool to the {{IMSMANG}} database, including reporting tools, other database packages and SQL management tools. Examples include:
{| class="wikitable"! scope="col" | Reporting tools || scope="col" | Database packages || scope="col" | SQL management tools|-*| Crystal Reports|| Microsoft Access || PGSQL Query Browser*|-| ArcGIS Desktop*iReport*Microsoft Excel Database packages *Microsoft Access*|| OpenOffice Base|| Navicat|-*| iReport || Microsoft SQL Server*Oracle|| TOAD SQL management tools*PGSQL Query Browser|-*Navicat*TOAD | Microsoft Excel || Oracle || Heidi SQL*Heidi SQL|}
When connecting an external reporting tool to {{IMSMANG}}, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible to directly import or connect {{IMSMANG}} database tables in external tools and perform transformations within the external tools, the recommended method is to do transformations within the {{IMSMANG}} database using database views and then import the resulting views into the external tools.
