I’m trying to figure out the various ways I can connect to an oracle database. I need to write values from the database to the PI server. I’m wondering what the most straight-forward way to do this is (i.e. easy to setup and maintain) vs. what would be the best performance route (maybe more involved, but would be very efficient). The databases are on different servers.
I know there is the SDK, ODBC data access, and RDMB interfaces, and maybe other tools to use. If anyone has some thoughts I would really appreciate suggestions.