Tying Disparate Systems Together
We use a UNIX-based PIC database (vendor-supplied) to manage our GL and primary customer records. We cannot do away with this system for reasons beyond the scope of this discussion. However, we can export the data into SQL 7.0 and massage it. We cannot write back to the PIC database from SQL.
We use Office 2000 and would like to develop some Outlook Today screens for management that reflect a variety of data in the SQL database. MSFT introduced this idea years ago with some templates for customizing Outlook Today.
Has anyone done so? Specifically with SQL? Are there additional (read free) resources available to assist development?