eXtractorONE is capable of decomposing html pages into a tabular model in SQL Server.

You can filter on any element if you just need to extract data from web tables or any other component.

The advanced web connector in eXtractorONE can parametrize URLs to have them populated with a sequence to grab all pages.

eXtractorONE is also an RSS Reader. You can download any feed you want into a tabular model in SQL Server.

SOAP Web Services can be used to distribute data via the web. eXtractorONE can connect to any web service just by entering the WSDL URL. The parameters can be populated by values in the database of your company. I.e.: upload the VAT numbers of your complete supplier table to the VIES web service and retrieve the validity of the VAT number including the registered location. All data will be stored in readable tables. IT departments also tend to open data via WSDL web services for other departments. As the data is distributed in XML format eXtractorONE is the right choice.

Many companies are investing in API’s. Social Media providers support the use of APIs. Thousands of companies open their data for research or integration reasons. Some organizations make more money with selling their data than selling their core products. With eXtractorONE you can download data from lots of APIs just by entering the API URl with a token. You can populate dynamically the parameters with your database content. Download certain tweets via the Twitter API, find the location via BING Maps API, translate the tweets via Google Translate API.

XML and JSON is everywhere. It’s not only distributed via web services. You can find it in meta data repositories of Business Intelligence tooling, application data or in XML files used for messaging. eXtractorONE shreds all the elements into a tabular model in SQL Server. Self-referencing nodes are recognized and flattened into a hierarchy table. There is no limit on the size, the data will be streamed into memory and RAM will be cleared when a part of the data is stored in the database. XML files are handled with mixed content model on complex types. eXtractorONE doesn’t need a schema. All you need is the source.

eXtractorONE can convert SQL syntax of several database types to XML. Second step is to split all the elements of the SQL syntax into database tables.

With this functionality you can easily ask which columns and tables are used in SQL code in Business Intellgence reporting tools (like SSRS, IBM Cognos) or ETL tools (like Informatica Powercenter, SSIS).

eXtractorONE can also decompose SQL views. This functionality leverages your Business Intelligende system.

eXtractorONE is able to invoke all API endpoints and WSDL Web Services.  But in some cases it could be more user-friendly to utilize an intuitive user interface, which makes it even simpler for the user to create the selections he needs in order to extract data from the web. eXtractorONE has, for example, different API connectors for Twitter, Facebook, LinkedIN, Youtube, Google Analytics, Walmart, Bol.com, Zalando, BestBuy and RDW.

Business Intelligence and Marketing Intelligence managers would love to have semi-structured data in the same format (and location) as their company data, so they can integrate it with local data or make use of their existing reporting tools to query on that ‘unreadable’ format. Lots of corporate data is still stored in the traditional relational data model and has a popular and ready-made query language: SQL. So why not convert those XML and JSON documents into a tabular model in a database like MS SQL Server? eXtractorONE can do it for you in a few clicks away!

Especially XML can have elements, deeply nested within each other in complex ways. Shredding all the elements into a readable format in a tabular model requires lots and lots of coding. Code generators and ETL software still need advanced modeling skills. Many objects need to be created manually and knowledge is required of schema validation. Like Meta Manager tools, all these implementations are limited to the predefined bridges. With eXtractorONE you no longer need to have developers working on scripting to shred that data into a table structure. Changes are captured automatically.

eXtractorONE automatically saves the changed data in a snapshot layer. A third layer generates automatically a ‘history on history’ layer: Changed, New and Deleted rows are stored with a Valid Date (from/to), a Valid Indicator and a Surrogate Key. eXtractorONE uses the location in the source document as a Primary Key which is often sufficient to determine changes. eXtractorONE also provides the capability to configure manually primary keys if the automatic generation doesn’t meet the criteria. In case you have thousands of documents to process, don’t worry, eXtractorONE compares the data with earlier shredded data.