A method of making unstructured text data available to structured data tools, the method comprising: accessing a source of unstructured text data; extracting the unstructured text data; writing the extracted unstructured text data to a capture schema; sending the extracted unstructured text data to a transformation tool; transforming the extracted unstructured text data with the transformation tool by extracting individual pieces of data and corresponding entity data, determining relationships between the extracted individual pieces of data, and grouping extracted pieces of data based on rules or algorithms; writing the transformed unstructured data to the capture schema, wherein the capture schema is a database schema having data tables and relationships between the tables for holding individual pieces of data, extracted entity data for the individual pieces of data, attributes associated with the extracted entity data, entity occurrences in the source, relationships between each of the individual pieces of data, attributes associated with the relationships, and relationship occurrences in the source; loading and mapping the transformed unstructured data from the capture schema to a structured analysis schema through an extraction/transform/load ETL layer, wherein the analysis schema comprises a data schema that provides structured data analysis tools access to the transformed unstructured data; and providing data connectors that allow the structured data analysis tools to access the structured analysis schema; characterized by the data connectors being adapted to pre-populate metadata of the structured data analysis tool with tables, columns, attributes, data and metrics from the analysis schema without performing tool customization or application specific setup and to provide embedded hyperlinks that point to underlying data sources. accessing a source of unstructured text data; extracting the unstructured text data; writing the extracted unstructured text data to a capture schema; sending the extracted unstructured text data to a transformation tool; transforming the extracted unstructured text data with the transformation tool by extracting individual pieces of data and corresponding entity data, determining relationships between the extracted individual pieces of data, and grouping extracted pieces of data based on rules or algorithms; writing the transformed unstructured data to the capture schema, wherein the capture schema is a database schema having data tables and relationships between the tables for holding individual pieces of data, extracted entity data for the individual pieces of data, attributes associated with the extracted entity data, entity occurrences in the source, relationships between each of the individual pieces of data, attributes associated with the relationships, and relationship occurrences in the source; loading and mapping the transformed unstructured data from the capture schema to a structured analysis schema through an extraction/transform/load ETL layer, wherein the analysis schema comprises a data schema that provides structured data analysis tools access to the transformed unstructured data; and providing data connectors that allow the structured data analysis tools to access the structured analysis schema; characterized by the data connectors being adapted to pre-populate metadata of the structured data analysis tool with tables, columns, attributes, data and metrics from the analysis schema without performing tool customization or application specific setup and to provide embedded hyperlinks that point to underlying data sources.