Netezza Corporate Reference Data Tool

Ntegra helped a customer use Microsoft SharePoint to manage and send Corporate Reference data via ODBC to a connected data warehouse. This featured a full integration of the Netezza Reference data warehouse, Reference data management within datasheet views, delivery notification, alerts, user triggers buttons (triggered by PowerShell scripts) and itemised user permissions.
 
SharePoint 2007 and 2010 offers a range of Business Connectivity services to any relational databases, Oracle and database warehouses using either integrate functionality (i.e. BCS/BDC) or ODBC connections. For those users, who may not know how to code PL/SQL or MYSQL, SharePoint can provide a friendly user interface to meet your system requirements.