Data Management Interface—Excel Connection
A Database DMI with an Excel Dataset is now able to read or write directly to the Excel file without opening the Excel application in the background. This improves performance and allows the DMIs to work when Excel is not installed, such as when running in the cloud.
Figure 3.1 is a screenshot of the configuration in the Excel dataset. The new connection process is the default. In most cases, this is the preferred process, but if you rely on Excel to open the workbook and evaluate formulas, you should select the Open Excel in the background option.
Figure 3.1 Excel Dataset Connection process option
See Connection Process in Data Management Interface (DMI) for more information on this method.
Revised: 12/01/2020