Query (cloud) data sources with Invantive Query Tool

Easily query and maintain data in over 75 data sources using familiar SQL statements.

The following data sources are available as live cloud and database data to access through familiar SQL statements using Invantive Query Tool. The SQL-statements can be run on Invantive Query Tool and easily re-used across all whole Invantive SQL-based of products on Windows, MacOS and Linux. Invantive PSQL adds procedural options and Invantive Script eases local data exchange using export and import. Invantive Query Tool scales from small to large enterprises through the solid foundation on Invantive SQL, including many complex data filters, and parallel execution using high-performance streaming of data.

  • ActiveCampaign SQL Query Tool

    ActiveCampaign is cloud software to automate the marketing, sales and support process of prospects, leads and customers. ActiveCampaign includes email campaigns, sales management, website integration, chat and advanced automatic workflows.

    The ActiveCampaign SQL Query Tool contains 66 tables.

  • AFAS Online SQL Query Tool

    AFAS Online is online accounting, ERP and payrolling software for Dutch companies. AFAS Online has approximately 15.000 customers, including most of the top 30 accounting firms in the Netherlands. AFAS Online is the cloud version of the AFAS Profit business software. AFAS Online runs on a hosted Windows remote desktop session - similar to AFAS Profit - providing easy access to large volumes of business data. AFAS can manage hundreds of companies per environment.

    Tables available with the AFAS Online SQL Query Tool.

  • Autotask SQL Query Tool

    Autotask is cloud software for IT business management. Autotask covers traditional ITIL processes as well as more recently introduced methods.

    The Autotask SQL Query Tool contains 3.396 tables.

  • Chargebee SQL Query Tool

    Chargebee is subscription billing software in the cloud for SAAS providers. It covers billing, subscription management and auto invoicing. Chargebee is used by over 2000 SaaS companies.

    The Chargebee SQL Query Tool contains 75 tables.

  • CIR SQL Query Tool

    Centraal Insolventieregister ("CIR") is an extensive Dutch online register containing all companies that went bankrupt or have filed for chapter 11, plus all persons with debt restructuring.

  • Comma-separated Values SQL Query Tool

    Comma-separated values ("CSV") is a text format for data. A CSV file typically stores data elements separated by a comma. The CSV file format is defined by RFC 4180.

  • Company.info SQL Query Tool

    Company.info are Dutch online software services for a large number of data-related tasks such as credit checks and accessing public registers such as Ultimate Beneficiary Owner ("UBO").

    The Company.info SQL Query Tool contains 295 tables.

  • Discourse SQL Query Tool

    Discourse is a cloud forum and mailing list management software application. Discourse can be used to increase community co-operation. The source is available as open source. Discourse runs for over 1,500 companies.

    Tables available with the Discourse SQL Query Tool.

  • DocumentCloud SQL Query Tool

    DocumentCloud is an online archive of documents collected mostly by journalists.

    The DocumentCloud SQL Query Tool contains 6 tables.

  • Dropbox SQL Query Tool

    Dropbox is an online file storage service with integrated collaboration features. It integrates into many platforms such as Windows and MacOS.

    Tables available with the Dropbox SQL Query Tool.

  • Exact Online SQL Query Tool

    Exact Online is cloud software for accounting and ERP. In the Netherlands, Exact Online also includes online payrolling software. It is used for approximately 400.000 companies.

    The Exact Online SQL Query Tool contains 1.124 tables.

  • Facebook SQL Query Tool

    Facebook is an online social network consisting of social activity by users as well as advertorials by campaigners.

    Tables available with the Facebook SQL Query Tool.

  • Freshdesk SQL Query Tool

    Freshdesk is a cloud solution for customer management. Freshdesk includes CRM as well as tickets. Existing functionality of Freshdesk can be extended by custom fields.

    Tables available with the Freshdesk SQL Query Tool.

  • GitLab SQL Query Tool

    GitLab is online software management software. GitLab includes GIT for version management, issue tracking and automated builds.

  • HTML SQL Query Tool

    HTML is a file format for information intended for human consumption. It includes text elements as well as graphical elements.

  • IBM DB2 UDB SQL Query Tool

    IBM DB2/UDB is a traditional database platform accessible through an ANSI SQL dialect.

  • JIRA SQL Query Tool

    JIRA is cloud software for managing business processes and sharing knowledge. JIRA Cloud offers tickets and customized workflows. JIRA Service Desk extends those by integration of external parties in business processes, such as service desk customers. Confluence is online collaboration software for sharing knowledge.

    Tables available with the JIRA SQL Query Tool.

  • JSON SQL Query Tool

    JSON is a file format based upon JavaScript. A JSON file consists of a key names and their values. Lists of keys can be combined in groups using arrays.

  • Kadaster SQL Query Tool

    The Dutch Kadaster is a public register of spatial data of the Netherlands. It bundles land, housing and infrastructure data in structured and graphical formats.

    The Kadaster SQL Query Tool contains 4 tables.

  • Knack SQL Query Tool

    Knack is software to create online databases without coding.

    Tables available with the Knack SQL Query Tool.

  • Logius COR SQL Query Tool

    Logius COR provides all issued Organisation Identification Numbers (OIN). Governmental and general interest organizations that exchange digital information using Digikoppeling Standaard can be assigned an OIN.

    Tables available with the Logius COR SQL Query Tool.

  • Loket.nl SQL Query Tool

    Loket.nl is online payroll software. Payrolling and HR are offered according to Dutch legislation. Loket.nl is used both by accounting firms as well as entrepreneurs.

    The Loket.nl SQL Query Tool contains 609 tables.

  • Mendix SQL Query Tool

    Mendix is a software platform for cloud applications. Based upon business logic, Mendix enables cost-effective deployment of business functionality on the web.

  • Microsoft Excel SQL Query Tool

    Microsoft Excel is an Office application which supports the XLSX file format for spreadsheets.

  • MySQL SQL Query Tool

    MySQL is a traditional database platform which supports ANSI SQL. MySQL is often used for small web applications.

    Tables available with the MySQL SQL Query Tool.

  • NDJSON SQL Query Tool

    NDJSON is a file format based upon JavaScript. A NDJSON file consists of one record in JSON-format per line. No array grouping or record separator is used.

  • NMBRS SQL Query Tool

    NMBRS is payroll software in the cloud. Nmbrs provides both payrolling as well as HR functionality. Payrolling for both the Dutch as well as Swedish legislation are available. NMBRS is used by entrepreneurs and accounting firms.

    Tables available with the NMBRS SQL Query Tool.

  • OData SQL Query Tool

    OData is both a data format and language to specify actions. OData is used by many cloud platforms to open up their data managed to the customers.

  • OpenArch SQL Query Tool

    OpenArch is cloud software for research. OpenArch combines numerous genealogical sources in the Netherlands. The data is typically cleaned from the original sources.

    The OpenArch SQL Query Tool contains 12 tables.

  • OpenSpending SQL Query Tool

    OpenSpending is an online web service on the budget and spending of governments in the Netherlands. It includes data from various sources, including IV3 of CBS.

    The OpenSpending SQL Query Tool contains 8 tables.

  • Oracle SQL Query Tool

    Oracle is a traditional database platform. Oracle supports ANSI SQL plus many extensions. Oracle is typically used for large business-critical applications.

    Tables available with the Oracle SQL Query Tool.

  • PayPal SQL Query Tool

    PayPal is an online payment provider. PayPal ensures that the monetary transfer for a service is handled correctly globally.

    Tables available with the PayPal SQL Query Tool.

  • PostgreSQL SQL Query Tool

    PostgreSQL is a database platform. PostgreSQL is based upon open source and runs ANSI SQL statements.

    Tables available with the PostgreSQL SQL Query Tool.

  • RDW SQL Query Tool

    RDW is the Dutch register for vehicles. The RDW data is available online, even up to specific license plates registered in the Netherlands.

    The RDW SQL Query Tool contains 56 tables.

  • Robaws SQL Query Tool

    Robaws is cloud software. Robaws helps construction companies manage their business.

    The Robaws SQL Query Tool contains 209 tables.

  • Roller SQL Query Tool

    Roller is online software for leisure and retail management. Roller is available globally.

    The Roller SQL Query Tool contains 41 tables.

  • RSS SQL Query Tool

    RSS is a file format to communicate news messages and other streaming data.

    Tables available with the RSS SQL Query Tool.

  • Salesforce SQL Query Tool

    Salesforce is an online ecosystem. Salesforce originated as a CRM solution, but was extended to cover many more types of online applications by Salesforce partners.

    Tables available with the Salesforce SQL Query Tool.

  • Simplicate SQL Query Tool

    Simplicate is cloud software for project management, project control and billing. The online Simplicate business software manages sales, CRM, hours, projects and invoices. Simplicate is typically used by entrepreneurs in the Netherlands in their service business processes, involving large numbers of projects.

    The Simplicate SQL Query Tool contains 248 tables.

  • Slack SQL Query Tool

    Slack is online collaboration software. Slack offers channels in which users can exchange messages.

  • Snelstart SQL Query Tool

    Snelstart is online accounting software. Snelstart is typically used by both entrepreneurs as well as accounting firms in the Netherlands.

  • SQL Server SQL Query Tool

    Microsoft SQL Server is a traditional database platform. SQL Server supports ANSI SQL. It is available both as a cloud database on Microsoft Azure as a traditional database running on-premise or hosted.

    Tables available with the SQL Server SQL Query Tool.

  • StackOverflow SQL Query Tool

    StackExchange is online collaboration software. Most popular variant is StackOverflow which is used by millions of software developers globally.

    Tables available with the StackOverflow SQL Query Tool.

  • Teamleader Focus SQL Query Tool

    Teamleader is a cloud solution for customer management. Teamleader includes CRM as well as project and tickets. Teamleader can be extended by defining custom fields on several core concepts.

    The Teamleader Focus SQL Query Tool contains 243 tables.

  • Teradata SQL Query Tool

    Teradata is a traditional database platform. Teradata targets large volumes of data, using a massive parallel architecture.

  • Tweede Kamer (NL) SQL Query Tool

    Tweede Kamer (the Netherlands) provides Public Data from the Tweede Kamer of the Netherlands, such as members and bills that might evolve to law. The Tweede Kamer is the House of Representatives of the bicameral parliament of the Netherlands. It has 150 members.

    Tables available with the Tweede Kamer (NL) SQL Query Tool.

  • Twinfield SQL Query Tool

    Twinfield is an online accounting package used in the Netherlands and Belgium. Accounting professionals form a large part of the Twinfield user community.

    The Twinfield SQL Query Tool contains 128 tables.

  • Twitter SQL Query Tool

    Twitter is an online social network in which short messages are exchanged by the global user community.

  • VirusTotal SQL Query Tool

    VirusTotal is a web site of Google for analysis and queries on malware infections on files.

    The VirusTotal SQL Query Tool contains 6 tables.

  • Visma Severa SQL Query Tool

    Visma Severa is cloud-based project management software. Visma Severa is available in the Nordics and the Netherlands.

    The Visma Severa SQL Query Tool contains 263 tables.

  • Visma.net Financials SQL Query Tool

    Visma.net is online software for accounting. Visma.net is used both by large accounting firms as well as large entrepreneurs.

    Tables available with the Visma.net Financials SQL Query Tool.

  • Wikipedia SQL Query Tool

    Wikipedia is online software for encyclopedical knowledge. Wikipedia handles both the collection, sharing and maintenance of large volumes of encyclopedical knowledge across a wide range of languages.

    Tables available with the Wikipedia SQL Query Tool.

  • XML SQL Query Tool

    XML is a file format for structured storage of data. XML resembles HTML, but the contents are more strictly matched against the metadata.

  • XML Audit File Afrekensystemen SQL Query Tool

    XAA ("XML Auditfile Afrekensystemen") is a file format for Dutch cash registers. It is generated by some cash registers for communication with accounting software and/or the tax office.

    Tables available with the XML Audit File Afrekensystemen SQL Query Tool.

  • XML Audit File Financieel SQL Query Tool

    XAF ("XML Auditfile Financieel") is a file format for Dutch accounting information. It is typically generated by accounting software for communication with other parties and/or the tax office.

    The XML Audit File Financieel SQL Query Tool contains 48 tables.

  • XML Audit File Salaris SQL Query Tool

    XAS ("XML Auditfile Salaris") is a file format for Dutch payrolling information. It is typically generated by payrolling software for communication with other software and/or the tax office.

    The XML Audit File Salaris SQL Query Tool contains 36 tables.

  • YouTrack SQL Query Tool

    YouTrack by JetBrains provides bug tracking, issue tracking system and project management.

    The YouTrack SQL Query Tool contains 379 tables.

  • Yuki SQL Query Tool

    Yuki is online accounting software from Visma. Yuki specializes in automated processing of documents in the Netherlands.

    Tables available with the Yuki SQL Query Tool.

  • Zoom SQL Query Tool

    Zoom is video, phone and web conferencing software.

    The Zoom SQL Query Tool contains 194 tables.