 |
 |
 |
 |
 |
 |
|
|
|
||||||||||||||
IntelliJade
is a powerful tool, which will allow you to quickly access your data.
The main goal of IntelliJade is to require from the user a minimum
of actions to gain full performance in the analysis, production and restitution
of the information regardless of the support desired (paper, files or web)
IntelliJade for Business allows you to be connected with the major relational databases (Oracle, SQL server, DB2-400, Access).
Multi-Connection
Usually, it requires a lot of configuration before it is possible to access data from different databases. Within itself, Jade has a driver for iSeries/400, without installing anything on the iSeries/400! With OLE DB functionalities built-in to IntelliJade, you can access the other major Databases on the market.
Data Query Creation
Users can be defined in groups and you can set privileges to a particular element such as queries, data models, etc. IntelliJade presents you the list of tables and views in your database. You can filter the list for an easy access to your frequent used tables. With Drag-And-Drop, you can create links between with the fields you have defined. Data model can be saved on your server for further use, or to share among other users.
Data model creation is interactive and easy to visualize. Stored data models may serve as a complementary analysis. The Data model print out allows you to see the links for each table. This constitutes a complement to your database, as well as a discussion support for developers and users.
You can use multiple relationships between tables: such as inner join, outer join (left, right and full) and exception join, independently on fields belonging to tables or calculated fields.
In order to have the model as clear and visually attractive as possible, colors are left to your choice. After selecting your tables, creating your relations and choosing your fields, IntelliJade automatically creates SQL queries.
You can :
- Create simple to complex selections;
- Create Ascending and Descending sorts;
- Create summations, averages, etc.;
- Create Group of records
- Create pivot tables.
Data Mining
You can visually and rapidly build your data analysis with IntelliJade powerful functionalities:
- Filter the data of the query on your server or the client.
- Sort data
- Group your data on several fields and Drill down
- Calculate totals, average, minimum and maximum values, etc.
Information Presentation
The data can be viewed on-screen, printed, represented as a graphic, whether it is a pie, bar or line graphic, or exported in different popular formats such as ExcelÓ, WordÓ, XML, HTML, etc.
The queries can be scheduled for an automatic execution.
Preview Image
Choice of several graphs: Pie, Bar or Lines - simple design or 3D.
Data Exporting
Export to different formats such as Excel, Word, XML, HTML, etc.
Web Browser
IntelliJade contains its own http Server, allowing instant access to queries defined in IntelliJade from an web browser. List queries, as well as chart queries can be viewed through Intranet or the Internet if you desire.
This type of web site can be independent or integrated to an existing web site.
IntelliJade comes with a web portal, which gives an easier access to saved queries
Business Intelligence Solution Benefits
Easily Integrate the Solution to your Company
|
Rapid and seamless integration |
IntelliJade comes with an installer that will check for all the information it needs to be properly configured. Then, within minutes after your first startup you can have access to all your databases and start designing your first query.
|
|
Get access to all your data, from one screen |
IntelliJade gives access to all databases, data models and requests based on access privileges. With IntelliJade, access data through OLE DB on multiple relational database format: SQL server, iSeries, Oracle, etc... Create any query and share the outcome using the format that best fits your company's needs: HTML, text reports, Excel, email, etc...
|
|
IntelliJade already has its own iSeries/400
driver.
|
No additional installation is required. IntelliJade's unique iSeries/400 driver is what comes the closest to machine instructions. No files will be installed on your servers. |
|
An additional layer of security |
Whether your servers already have secure database access or not, IntelliJade provides an extra security procedure that is complement to the system already in place, local or on a web basis. Nobody can access your data without the proper permission.
|
|
Implement according to your needs
|
IntelliJade's flexibility and scalability is perfect for a single department or to become a company-wide standard. Use it for your decision-makers as a Business Intelligence Solution, or make it your portal for employees, clients and partners.
|
Learn Basics with IntelliJade
|
Intuitive web interface |
IntelliJade's Windows user interface enables you to easily create custom graphs, reports and export your data in a fully customizable view. Publish a table, a report or a dashboard on a web server, or send by email, only with a simple click!
|
|
Editable SQL code |
IntelliJade automatically creates SQL statements with the visual interface : Choose your tables, your fields and create relationships with drag & drop. Edit the automatically generated code for more flexibility.
|
| Publish dynamic data without the knowledge of HTML |
IntelliJade has an integrated web server. Create your own web portal with IntelliJade or integrate the new applications within your existing web services with professional and efficient results. No knowledge of HTML is required·
|