Adding a Shared Data Source

Once you add the Innovator Reports Folder, navigate into it by clicking on the link. Now, you add a Shared Data Source for the Reports to use to connect to the database.

1. Click + and then Data Source inside the Innovator Reports folder.

   

   

   Figure 22.

   The New data source dialog appears.

   

   

   Figure 23.

2. Enter innovator_regular for the Data Source Name.

   Note

   By using this same name for both the development and production servers, exporting and importing Reports becomes simpler because there is no need to reassign the Data Source for the Reports you import.

3. Enter the following for the Connection String replacing the values for the two parameters with the actual server name where SQL Server is installed as well as the actual database name.

data source=<SQLServerName>;initial catalog=<InnovatorDatabase>

e.g.

data source=MyServer\MSSQLSERVER2019;initial catalog=InnovatorSolutions

4. Select the Using the following credential choice for the Connect Using field and enter the DB Client Login credentials for your database.
5. Click Create to deploy the shared Data Source.