Database connections
Configure database connection settings
The database connection that is used by Data Hub can be changed by either connecting to a different database or create a new one.
To make the change, click the Database Connection link on the Settings tab.
The Database Connection screen appears with connection options.
New database connection settings
On the Database Connection screen, select the Connect to New Database option and specify the following settings:
External URL
Use this text box to specify the URL that will be used to access ZAP Data Hub from any client computer. The default value provided can be retained if desired.
Server
Use the server name if the Microsoft SQL Server instance is on the same network as the ZAP Data Hub server. Otherwise, a fully qualified domain name (FQDN) is required.
Authentication
Depending on how your Microsoft SQL Server is configured, authentication credentials are provided by either:
Windows Authentication. Select to use a Windows user name and password to connect to the Microsoft SQL Server. Active Domain credentials are also accepted.
SQL Server Authentication. Select to use a SQL Server user name and password to connect to the Microsoft SQL Server.
Create a database using a specified Windows account
To run Data Hub as a specified Windows user, check this option and provide the login details for the intended user account. By default, Data Hub operates under the Windows application pool (NT AUTHORITY\NETWORK SERVICE). If the application pool identity doesn't have permission to create SQL Server databases, the database creation step will fail.
Application Database
Specify the name of the new database. The name you enter is checked against any existing databases on the selected server. If the name is unique, a green checkmark appears to the right of the text box.
License
Enter the license key for the instance of ZAP Data Hub being installed. This key is provided by either:
Your account manager or partner.
The Support Center website.
Once the key is verified, a green checkmark appears to the right of the text box.
Security Configuration
This allows you to specify the type of user authentication used with this instance of Data Hub.
Click CREATE.
Existing database connection settings
On the Database Connection screen, select the Connect to New Database option and specify the following settings:
Server
The name of the server hosting SQL Server to which the installation wizard will connect and on which the existing database is hosted. If the SQL Server instance is a named instance, follow the server name with a backslash and the instance name.
Authentication
Specify how you will connect to the server hosting SQL Server (specified in the previous setting). If you select the SQL Server login option, you'll need to specify a user name and password combination for connecting to the specified SQL Server host.
Application Database
Specify the name of the existing database. If the name is valid, a green checkmark appears to the right of the text box.
3. Click CONNECT.