Example: Infinity Database

Understanding what users see in the interface is helpful. But ultimately, you have to get closer to the transactional database that feeds the data warehouse. In the previous example, some information about interaction responses pointed to a location in the transactional database. In this example, the transactional database is explored.

You can establish a connection to an Infinity database through SQL Server Management Studio. To connect to the database engine, you can click File > Connect Object Explorer. The Connect to Server screen appears. There are some credentials to provide. You can fill in the necessary information and click Connect.

To open Object Explorer, you can click View > Object Explorer. Then you can browse to the Infinity database. In the previous example, we found Transact-SQL that references the [INTERACTIONRESPONSE] table. You can navigate to the table through Object Explorer.

And here is the table...

To quickly find tables, filter for the table within the Tables folder. Right-click the folder and click Filters > Filter Settings.