Search code examples
mysqllotus-noteslotus-domino

Getting a view in lotus notes out of data from MySQL

So I learned how to write data to a MySQL-database and how to read from it, too, using ODBC and in one case Lotus Script using ADODB, in the other case Formula Language using @DbLookup.

So since I try to get away from our huge mass of Lotus Notes Databases my first goal would be to get all this information into a MySQL, so I can work through the databases more slowly to not create a huge cut. But of course we also need views. So is there a way to create a view in Lotus Notes that uses data from a MySQL-Database? Or would I have to still store the data in Notes and additionally in the MySQL-Database to do that?

Solution

  • There's a feature like that for DB2, but not for MySQL or any other database.

    The best you can do is use synchronization tools like IBM Enterprise Integrator for Domino or one of the many available third-party alternatives.