Does FactoryTalk Transaction Manager only work with Oracle or SQL Server?
No, FactoryTalk Transaction Manager has a generic ODBC interface that can connect to virtually any vendor’s database; however, it is important to know that the ODBC specification is “open to interpretation” to some extent, and not all vendors code their drivers the same. Therefore, there are sometimes issues that arise when connecting to the lower volume databases. Oracle and SQL Server do comprise the largest amount of testing that the FactoryTalk Transaction Manager teams performs, so they have the most mileage on them for driving out database specific issues.