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:
It is also possible to define a SOAP or REST endpoint. The server can be called with the endpoint <server>/api/v1/soap/<modelname>. A REST interface can be called by using <server>/api/v1/rest/<modelname>.
The soap or rest call must be of a certain format.
For the creator of a model, the REST interface is not that interesting. You add some data to a definition, and get some information back.
With the REST definition file, a more technical person can create the interface, so the model creator can focus on the content of that model.
For the creator of a model, the SOAP interface is not that interesting. You add some data to a definition, and get some information back.
With the SOAP definition file, a more technical person can create the interface, so the model creator can focus on the content of that model.
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 or REST and local XML files. BBIS-server connections are also also regarded as ‘external data’, but beyond the scope of this article.
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: