Data integration tool
Computer-implemented systems and methods are disclosed for providing proactive validations of transformation scripts. In one implementation, a method is provided that includes associating, with at least one processor, the transformation script with ontology parameters. The method also includes initiating a debugging operation of the transformation script having at least one condition and importing, from a data source, at least one data item for transformation. The method further includes determining, as part of the debugging operation, whether the at least one condition that uses the at least one data item is valid based on the ontology parameters and notifying a user, on a display device, of a result associated with the determination.
1. A system for providing a proactive validation of a transformation script, the system comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the system to:
initiate a debugging operation of the transformation script having at least one condition wherein the transformation script uses a builder that defines the definition of the entity as the entity being an object or a property of an object;
import, from a data source, at least one data item for transformation;
determine, as part of the debugging operation, the at least one condition that uses the at least one data item is invalid, wherein the at least one condition is determined invalid based on an assignment of an entity associated with the transformation script and a definition of the entity;
associate the transformation script with ontology parameters, the determination the at least one condition that uses the at least one data item is invalid being based on the ontology parameters, wherein the ontology parameters include parameters that assign the entity as being an object or a property of an object, wherein the transformation script includes information for mapping at least a portion of the at least one data item to at least one of the ontology parameters; and
provide an indication of a result associated with the determination, wherein the result is at least one of an implicit result or an expressed result.
2. The system of claim 1 , wherein providing the indication of the result comprises any of displaying an error message, an acronym, a number, or a graphic.
3. The system of claim 1 , wherein the indication of the result is provided in any of a notification in a debugger application, an email, or a popup window.
4. The system of claim 1 , wherein the at least one condition is based on the data source.
5. A method for providing a proactive validation of a transformation script, the method being performed by one or more processors and comprising:
initiating a debugging operation of the transformation script having at least one condition wherein the transformation script uses a builder that defines the definition of the entity as the entity being an object or a property of an object;
importing, from a data source, at least one data item for transformation;
determining, as part of the debugging operation, the at least one condition that uses the at least one data item is invalid, wherein the at least one condition is determined invalid based on an assignment of an entity associated with the transformation script and a definition of the entity;
associating the transformation script with ontology parameters, the determination the at least one condition that uses the at least one data item is invalid being based on the ontology parameters, wherein the ontology parameters include parameters that assign the entity as being an object or a property of an object, wherein the transformation script includes information for mapping at least a portion of the at least one data item to at least one of the ontology parameters; and
providing an indication of a result associated with the determination wherein the result is at least one of an implicit result or an expressed result.
6. The method of claim 5 , wherein providing the indication of the result comprises any of displaying an error message, an acronym, a number, or a graphic.
7. The method of claim 5 , wherein the indication of the result is provided in any of a notification in a debugger application, an email, or a popup window.
8. The method of claim 5 , wherein the at least one condition is based on the data source.
9. The method of claim 5 , wherein the data source includes unstructured data or the data source includes structured data.
10. A non-transitory computer readable medium that stores instructions that are executable by at least one processor to cause the at least one processor to perform a method for providing a proactive validation of a transformation script, the method comprising:
initiating a debugging operation of the transformation script having at least one condition wherein the transformation script uses a builder that defines the definition of the entity as the entity being an object or a property of an object;
importing, from a data source, at least one data item for transformation;
determining, as part of the debugging operation, the at least one condition that uses the at least one data item is invalid, wherein the at least one condition is determined invalid based on an assignment of an entity associated with the transformation script and a definition of the entity;
associating the transformation script with ontology parameters, the determination the at least one condition that uses the at least one data item is invalid being based on the ontology parameters, wherein the ontology parameters include parameters that assign the entity as being an object or a property of an object, wherein the transformation script includes information for mapping at least a portion of the at least one data item to at least one of the ontology parameters; and
providing an indication of a result associated with the determination wherein the result is at least one of an implicit result or an expressed result.
11. The non-transitory computer readable medium of claim 10 , wherein providing the indication of the result comprises any of displaying an error message, an acronym, a number, or a graphic.
12. The non-transitory computer readable medium of claim 10 , wherein the indication of the result is provided in any of a notification in a debugger application, an email, or a popup window.