![]() Once an SQL Server data source has been added to your account, you can add SQL Server tables or views to any app. So for example, if the instance is called myInstance, use \myInstance as the server name. If a non-default instance name is being used for the SQL Server, provide that as part of the server name.For example, if the instance is running on port 2000, use ,2000 as the server name. If a non-default port number is being used, it should be provided as part of the server name. If your database is running on AWS, ensure that Network Security option Publicly Accessible is set to Yes and add a Security Group rule for the server that allows the AppSheet server IP addresses. See Manage IP address and firewall information. In order for AppSheet servers to access your data, both your network and SQL Server must accept inbound connections to the database from AppSheet servers. The system stores these values securely, and concatenates them to construct a connection string to the database To add an SQL Server data source, you'll be prompted to provide a server name, database name, username, password, and whether Secure Socket Layer (SSL) communication is required. Select SQL Server from the Type drop-down menu.The Add database connection information dialog displays. Enter a name for the data source and click Cloud Database or On-premises Database.To add an SQL Server data source to your AppSheet account: AppSheet can build apps from Microsoft SQL Server databases that are hosted in Amazon AWS, Microsoft Azure, or another cloud-hosting provider.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |