RemoteBI is a Remote Desktop Services (RDS) server that provides members of the university community a central location to access Business Intelligence (BI) development tools and resources. Additionally, it acts as a bridge to restricted data sources (i.e. data in the high security firewall context) that may not be directly accessible from a local workstation.
Tools installed on Remote BI include:
- Visual Studio Professional Edition
- SQL Server Data Tools
- Pragmatic Works Task Factory
- SQL Server Management Studio
- Power BI
- Attunity Oracle Drivers
- Amazon Redshift ODBC drivers
These tools are kept in parity with IDDM’s hosted Microsoft Data Platform infrastructure (shared services for SQL Server databases, SQL Server data marts, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services).
A current Visual Studio or MSDN license is required for access to RemoteBI and may be purchased at a reduced price through the Microsoft Select Program for the University of Iowa.
To request access to RemoteBI, complete the RemoteBI Server Access Request form and attach proof of a Visual Studio or MSDN license. Examples of proof include: purchase invoice, Visual Studio License Key, or an email confirmation of license from the Campus Software Licensing and Acquisition group.
Additional questions about the RemoteBI server can be directed to the ITS SQL Server Database Administration Team at: ITS-SQL-Help@uiowa.edu