There are many ways to examine, search, and mine data in the data warehouse. But before using any of them, you must understand how to get connected.
Connection methods will vary according to application. Some will require an ODBC system data source. Others will connect via something called OLEDB. Whatever the flavor of alphabet soup you use, for the relational part of the data warehouse you will generally need to enter two or more of the following parameters and values:
- A data source name: Usually a name you choose (e.g., MasterDimensions)
- A database type: Microsoft SQL Server 2012 Database
- An ODBC driver type: SQL Native Client (usually version 10.0 or 11.0)
- A server name: dwsql.ads.carleton.edu\PRODUCTION
- An authentication method: Trusted authentication (or Windows authentication)
To do data mining or OLAP cubes, a further connection to an Analysis Services database is required. Parameters for the Analysis Services connection are:
- A database type: Microsoft SQL Server Analysis Services (Microsoft OLAP cubes)
- An authentication method: Windows authentication (i.e., no username/password)
- A server name: dwcubes.ads.carleton.edu\production (or possibly dwcubes.ads.carleton.edu:62382)
Because of the diversity of applications that will be used with the data warehouse, and the complexity of setting them up in our current environment, it is impossible to anticipate every possible combination of parameters that will need to be entered. If you find yourself an an impasse and need help, contact the ITS Helpdesk and ask them to create a ticket of type Software > Data Warehouse > Training, and we (ITS) will schedule a time when we can set these things up for you, learn more about what you'd like to do, and help you get connected.