External Databases
External data sources such as ERP or MPR systems can be linked with the ATR CustomTools database. Use the External Databases options to set up connections between your ATR CustomTools database server and the external system you have.
Links defined in External Databases are server-specific connections. External Databases in ATR CustomTools are equivalent to Linked Servers in Microsoft SQL Server.
Changing connections between different databases located in the same SQL Server keeps the external database connections as they are. However, switching between different SQL Servers may cause differences in these connections depending on what external database connections are defined in each SQL Server.
The existing data sources are listed in the External Data Sources list.
| New | Opens the Add External Data Source dialog box. Create a new external data source link using this feature. |
| Delete | Deletes selected external data source(s). |
| Modify Login | Opens the Modify Login dialog box. You can change your login information used to log in to the external database. |
| Properties | Opens the External Data Source Properties dialog box, which shows properties of the selected data source. |