InfoStudio® Information Portal (coming soon)
InfoStudio Information Portal is a platform for making business intelligence and other content available to users from a single, well engineered and easy-to-use Web based interface. It allows you to consolidate reports, dashboards, links and documents together and secure them for groups of users. It also includes auditing that tracks who accessed each content item and provides usage and popularity reporting. InfoStudio Information Portal provides standardized parameter prompting for many content types, allowing you to set up dynamic cascading prompt lists that can be shared across content types.
InfoStudio Information Portal Features:
- Consolidates Business Intelligence Content from Disparate BI Systems
- Initial Release to support (MS-Reporting Services, Crystal Reports, QlikView)
- Provides shared and personal folders in which content and links can be organized
- Keep Hyperlinks to internal and external resources with other content
- Consolidate documents including Word, Excel, PowerPoint, PDF with other content
- Standardized parameter prompting for calling reports and BI content (or use native prompting)
- Built-in auditing tracks usage and popularity of content
- Simple, cost effective licensing for low and high volume scenarios
- More featured planned…
InfoStudio® SQL Author
InfoStudio is software that allows you to access data from most popular database systems including MS-SQL Server, Oracle, MS-Access, and most OLE DB or ODBC data sources using SQL. It is an excellent tool for learning and using SQL. You can see data structures, visually create and issue SQL statements, and access and edit data with InfoStudio.
Download InfoStudio SQL Author 5.0 (Zip) Download InfoStudio SQL Author 5.0 (msi)InfoStudio SQL Author Features:
- Connect to databases via ADO and ODBC (supports MS-Access, dBase, Paradox, SQL Server, Oracle, Sybase, Informix, and many others including most ODBC compliant data source
- Navigate and view table and column information including column data types and lengths in a data explorer interface
- Quickly sample data from columns to determine their purpose
- Create, Execute and Save SQL statements that retrieve, update, insert or delete data
- Execute SQL aggregate functions to get sums, counts, averages and other statistics. Great for report & software validation
- Use built in assistance to correctly write SQL statements.Point & click your way to a completed SQL statement
- Export data into MS-Excel, MS-Word, HTML, Rich Text, Plain Text, DIF
- Clipboard (automatically view data in Excel)
- Keep a catalog of your favorite connections and SQL statements.
- Store user ID’s and passwords for quick reconnects
- Access data in a grid format
- Search and Filter returned data from a SQL query