Working with SQL databases

Navigation:  Working with databases >

Working with SQL databases

Previous pageReturn to chapter overviewNext page

With object generation 4.60 we introduced connectivity to external SQL databases. You can connect to MySQL databases or Microsoft SQL server. For both systems basic versions are available which can be installed free of costs - at least this is the situation in 2018. This documentation does not cover the installation of the database server itself. It covers the SCOUT and CODE side of the connection only.

The treeview contains a branch called 'SQL database connection' which looks like this:

 

clip0032

 

The window gives access to several tabs which provide various database functions. Some of these functions are available as script commands as well - in that case you do not need to access the SQL database connection window.