Topics / interfaces

Microsoft Excel interfaces

It is possible to connect to the data of an Excel file by using the Excel-interface of the Publisher. This can be used with multiple sheets, and it is possible to both read from and write to Excel sheets. The file we will use in this example looks like this:

XML and SOAP connections

External data as interfaced in the Studio are data from other sources, not being databases. In this article, we expand upon the connections you can make with SOAP and local XML files. BBIS server and Fixed interfaces – both of which are also regarded as ‘external data’ – are beyond the scope of this article.

Database interfaces

The Publisher is able to connect to several types of databases. First you must make sure you have a connection defined using datasources. Once you have defined your MySQl/Firebird/Interbase/MS SQL/Oracle connection, you can go to Actions > Database. Pushing that button will open the following Window: