What would be the best way to validate data in a external database using python. Does anyone have any examples? Lets say that I wanted to check whether or not product categories were correct in a program called SAP what would be the best approach to do this?

CodePudding user response：

To get data from an database I would recommend to use sqlalchemy. They provide a huge toolset to get some insights of your database. Check out the SAP Hana connector to establish a connection.