"You have done a commendable Job. It is a very useful tool. I can see the sincerity and your dedication in the way you have shown each aspect of the tool. It will make a life easier for many. A very useful and unique concept." -Head IT, manufacturing company

"Solution by KG team to manage our legacy application and reporting requirements, provided when it was most needed in a short period. Team has done a tremendous job despite having no previous knowledge of the base application or database. No migration was required to a different database which resulted in cost and time saving. The solution was immediately accepted and acknowledged by senior management of the bank." -Vice President - IT, German Based ,
Investment Bank.


What are the prerequisites / environment required to use the DBLuminous?

Microsoft .Net Framework 2.0 SP2 & above, SQL Native Client and MS SQL 2005 & above for Client version. Microsoft .Net Framework 3.5, IIS 5.1 (or) IIS 6.0 and Browsers like Firefox 3.0.7 or Internet Explorer 7.0 (Preferred).

Does the application platform restrict the usage of DBLuminous?

DBLuminous (DBL) is designed to be used on multiple platforms. DBLuminous is independent of the platform of the application and the database. Currently DBLuminous has the ability to support major databases that include Oracle, MS SQL, Postgres, MySQL, Sybase and DB2. However, DBLuminous requires .NET framework and SQL database to host the metadata.

Is it possible to use multiple databases for an application?

Yes, DBLuminous can be configured to an application having multiple schema / database or databases from different applications. For example, if an ERP has separate databases for each of its domains such as Production, Sales, Accounts, and Purchase etc. then all of it can be configured under one application. DBLuminous will identify this as a single “schema set “.Extending the schema set concept, a schema set can be maintained for a database from multiple environments such as Development, Testing, and Production. This technique is very efficient for migrations and monitoring database across environments for consistency.

Are there any restrictions on number of databases that can be used in the tool?

The limit to the number of database is based on the licenses purchased (DBLuminous is licensed for number of databases) and there are no limitations to the number of databases that can be configured as long the required licenses are available. However, there is a soft limit of 99 databases for a group to allow usability of the organization.

Does DBLuminous inlcude reporting capability?

Yes. Reporting is the key component of DBLuminous. There are number of pre-formatted reports available as part of out of the box tool implementation. The latest information about the metadata will be available at runtime. Further, DBLuminous comes with a reporting engine, which can also be used to create additional reports similar to BI tools.

Does the tool retain the data content of database into its repository?

DBLuminous only stores the information about the metadata and does not retain the actual data content within a Database.

Is the tool intrusive and does the tool affect the performance of the application database?

DBLuminous is designed to function without affecting the performance of the database and is not intrusive. DBLuminous connects to the application database, only on demand, to collect, track metadata and other statistics as required. DBLuminous does not use any sniffers that are triggers that cause performance degradation of the database.

How does DBLuminous add value in a Data Warehouse Project?

Identifying the elements from disparate sources is the key aspect in designing an effective Data Warehouse. The performance and the effectiveness of the data warehouse depend on carefully choosing these elements to form the dimensions required for the data warehouse. Further, understanding the unique elements that have similar functional implications / meaning across multiple data sources are challenging in complex warehouse architecture. Building a metadata repository using DB Luminous (DBL) will provide the required knowledge of various databases and its elements. The Unique Data Element (UDE), Functional grouping features of DBL will allow you to group and analyze the elements of similar construct. These handy features significantly reduce time in creating a data warehouse. DBL is also useful as DW evolves to cater the constant requests from users to enrich the data. With DBL, it is easy to identify the source and granularity to enhance DW as needed.