Data Connections are SQL Server Database connection definitions used by Profitbase InVision when connecting to a SQL Server database for reading or writing data. To set up a connection, you need to specify the SQL Server instance name, database, and authentication information.
By setting up a Data Connection to a Profitbase Studio Solution database, you can associate one or more Profitbase Studio Solutions to the Data Connection.
By associating Profitbase Studio Solutions to Data Connections, you get access to the contents of the solutions. This allows you to reference Data Warehouse resources, such as Facts and Dimensions, for use in InVision solutions.
Data Connections can be added from the Data Store, Dimension and Fact Toolboxes, or the Data Connections menu item in the Application bar menu.
Existing Data Connections are maintained from the Data Connections menu item in the Application bar menu.