I'm new to the concept of connecting and using external Tables in NAV. In this specific case our customer want to use an external MySQL database together with NAV 2018 CU5. The development is going to be "old school" in C/AL via the development client.
NAV is supposed to read and write into these external Tables.
I know there is the table property TableType where you would (probably?) define the Table as ExternalSQL, that the fields in NAV and MySQL have to be identical (Order of Fields, Name, Type, Length) and that a connection has to be established to get the data from the MySQL database.
But I have no bloody clue how to create the connection and which other pitfalls to avoid. While one of my colleagues has some notion on how it should be, he's never done it with a MySQL Database.
So the three big questions: Can/Should you connect NAV 2018 to an external MySQL database? If yes, how can/should it be done? If no, why and what is a better alternative?
Thanks for any help in advance!