Contents
How to create a connection to an external database?
List the necessary tables and views on the external database. Perform the operations Create, Read, Update, and Delete on those tables and views. Click Create to create the Database Connection.
How to use an external database in integration studio?
In Integration Studio, create an extension module to map tables or views in the external database to OutSystems entities. In Service Center, configure the extension to use a database connection. In Service Studio, reference and use the extension in your application. The following sections go throught each one of these general steps in detail.
How to create and send the task module?
In the process of the initial invoke request, your service receives an Activity object of type composeExtension/fetchTask, and you must respond with a task object containing either an Adaptive Card or a URL to the embedded web view. Along with the standard bot activity properties, the initial invoke payload contains the following request metadata:
Where does the SQL Server module come from?
Finally, the module sql was imported from the Azure Marketplace. The SQL Server module comes with a default password set in the environment variables of the deployment manifest. Any time that you create a SQL Server container in a production environment, you should change the default system administrator password.
How to create external content types for SQL Server?
Click Add Connection, select SQL Server in the External Data Source Type Selection dialog box, and then click OK. In the SQL Server Connection dialog box, enter the name of the server, the database name, an optional description, and then click OK. To choose an authentication mode,…
How can I specify an external SQL Server database?
To specify the SQL Server database for the external content type, click Click here to discover external data sources and define operations. Click Add Connection, select SQL Server in the External Data Source Type Selection dialog box, and then click OK.