Custom connectors for Microsoft Power Query

Easily connect Microsoft Power Query to over 75 platforms using custom connectors and the OData4 protocol.

The following connectors are available for use with Microsoft Power Query with Invantive Cloud and other Invantive SQL-based products. The actual list of connectors may vary depending on the subscription and chosen options. When used with Microsoft Power Query, most people use the OData4 bridge to real-time retrieve the data directly into Microsoft Power Query. Each online connector provides support for downloading marketing and customer data, but also financial data into your data warehouse. Also, each Microsoft Power Query connector can be used as a data source for MacOS, Windows, Linux and other clients for data integration service, analytics and data integration. Data replication into SQL Server, PostgreSQL, MySQL and Oracle is also possible for enterprise and OEM with Invantive Data Replicator. Data Replicator provides support for a single large-scale data warehouse or multiple large-scale data warehouses, each containing over 1 terabyte of managed data.

  • Access Power Query connector

    Microsoft Access is database management software, combined with a user interface development environment. Microsoft Access is mostly used by business users for entry level business applications.

  • ActiveCampaign Power Query connector

    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 Power Query connector provides access to 66 tables of data.

  • Acumatica Power Query connector

    Acumatica Cloud ERP is online software for accounting and ERP. Acumatica Cloud ERP is used by mid-size companies. It also formed the technological basis of Visma.net Financials.

  • ADP Power Query connector

    ADP is online software for payrolling and human resource management. ADP provides similar services in many countries.

  • AFAS Profit Power Query connector

    Also known by the name: AFAS Online.

    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 accessible with the AFAS Profit Power Query connector.

  • Airtable Power Query connector

    Airtable is cloud software to manage data and develop small business applications. Airtable has an Excel-like user interface.

  • Asana Power Query connector

    Asana is online workflow management software for teams.

  • Autotask Power Query connector

    Also known by the name: Datto.

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

    The Autotask Power Query connector provides access to 3,396 tables of data.

  • Basecamp Power Query connector

    Basecamp is online software for project management and web application development.

  • Bouw7 Power Query connector

    Also known by the name: Exact Online Bouw.

    Bouw7 is a cloud solution for construction companies. Bouw7 is also known as "Exact Online Bouw" and integrates into Exact Online. Bouw7 also provides service and maintenance modules, plus CRM functionality.

  • Bullhorn CRM Power Query connector

    Bullhorn CRM is online human resource management-software for recruiting and staffing.

  • CBS.nl Power Query connector

    Also known by the name: Centraal Bureau voor de Statistiek.

    All published data sets from cbs.nl and informatie voor derden published by cbs.nl.

    Tables accessible with the CBS.nl Power Query connector.

  • Chargebee Power Query connector

    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 Power Query connector provides access to 75 tables of data.

  • Company.info Power Query connector

    Also known by the name: Webservices.nl.

    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 Power Query connector provides access to 295 tables of data.

  • Couchbase Power Query connector

    Also known by the name: Membase.

    Couchbase is a database management system based on NoSQL.

  • Discourse Power Query connector

    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 accessible with the Discourse Power Query connector.

  • DocumentCloud Power Query connector

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

    The DocumentCloud Power Query connector provides access to 6 tables of data.

  • Dropbox Power Query connector

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

    Tables accessible with the Dropbox Power Query connector.

  • ECB Exchange Rates Power Query connector

    The ECB Exchange Rates provides 90 days of history on exchange rates against the European Euro as established daily by the European Central Bank.

    The ECB Exchange Rates Power Query connector provides access to 2 tables of data.

  • Exact Online Power Query connector

    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 Power Query connector provides access to 1,124 tables of data.

  • Facebook Power Query connector

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

    Tables accessible with the Facebook Power Query connector.

  • Freshdesk Power Query connector

    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 accessible with the Freshdesk Power Query connector.

  • GitLab Power Query connector

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

  • Gripp CRM Power Query connector

    Gripp CRM is a cloud solution for customer management. Gripp includes CRM as well as projects, timesheets and workflows. Gripp can be extended by defining free fields on organizations, contracts, projects and other tables.

    The Gripp CRM Power Query connector provides access to 92 tables of data.

  • HubSpot Power Query connector

    HubSpot is cloud-based marketing, sales, CRM and service software. HubSpot is used by over 150.000 companies.

  • IBM DB2 UDB Power Query connector

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

  • ionProjects Power Query connector

    Also known by the name: ionBIZ.

    ionProjects is a cloud solution for project management. ionProjects focuses ICT, engineering and consultancy organization providing project management, resource planning, time registration and ticketing.

  • JIRA Power Query connector

    Also known by the name: JIRA Cloud.

    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 accessible with the JIRA Power Query connector.

  • Kadaster Power Query connector

    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 Power Query connector provides access to 4 tables of data.

  • Knack Power Query connector

    Knack is software to create online databases without coding.

    Tables accessible with the Knack Power Query connector.

  • Logius COR Power Query connector

    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 accessible with the Logius COR Power Query connector.

  • Loket.nl Power Query connector

    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 Power Query connector provides access to 609 tables of data.

  • Mendix Power Query connector

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

  • Minox Power Query connector

    Minox is an online accounting package used in the Netherlands by entrepreneurs and accounting professionals.

  • Monday.com Power Query connector

    Monday.com is online software for project management and custom applications.

  • MySQL Power Query connector

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

    Tables accessible with the MySQL Power Query connector.

  • NASA Power Query connector

    NASA provides NASA data, including imagery, available for reporting. NASA combines asteroid data, earth data, pictures and Mars-rover pictures

    The NASA Power Query connector provides access to 10 tables of data.

  • NMBRS Power Query connector

    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 accessible with the NMBRS Power Query connector.

  • OData Power Query connector

    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.

  • Odoo Power Query connector

    Odoo is online ERP and CRM-software. Odoo is used by small and mid-size companies as well as large accounting firms.

  • Open Exchange Rates Power Query connector

    Open Exchange Rates provides historical and current exchange rates for over 200 commonly traded currencies.

    The Open Exchange Rates Power Query connector provides access to 8 tables of data.

  • OpenArch Power Query connector

    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 Power Query connector provides access to 12 tables of data.

  • OpenSpending Power Query connector

    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 Power Query connector provides access to 8 tables of data.

  • Oracle Power Query connector

    Also known by the name: Oracle RDBMS.

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

    Tables accessible with the Oracle Power Query connector.

  • PayPal Power Query connector

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

    Tables accessible with the PayPal Power Query connector.

  • PipeDrive Power Query connector

    PipeDrive is cloud-based CRM and sales software. PipeDrive is used by over 100.000 companies.

  • PostgreSQL Power Query connector

    Also known by the name: Postgres.

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

    Tables accessible with the PostgreSQL Power Query connector.

  • QuickBooks Power Query connector

    QuickBooks is on-premises accounting software for small and medium-sized companies.

  • QuickBooks Online Power Query connector

    QuickBooks Online is online accounting software for small and medium-sized companies.

  • RDW Power Query connector

    Also known by the name: Rijksdienst voor het Wegverkeer.

    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 Power Query connector provides access to 56 tables of data.

  • Robaws Power Query connector

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

    The Robaws Power Query connector provides access to 209 tables of data.

  • Roller Power Query connector

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

    The Roller Power Query connector provides access to 41 tables of data.

  • RSS Power Query connector

    Also known by the name: Really Simple Sindication.

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

    Tables accessible with the RSS Power Query connector.

  • Salesforce Power Query connector

    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 accessible with the Salesforce Power Query connector.

  • ServiceNow Power Query connector

    ServiceNow is online software to automate and manage workflows for large enterprises. ServiceNow is typically used for IT service management.

  • Simplicate Power Query connector

    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 Power Query connector provides access to 248 tables of data.

  • Smartsheet Power Query connector

    Smartsheet is online software for collaboration and workflow management.

  • SnelStart Power Query connector

    SnelStart is online accounting software. SnelStart is typically used by both entrepreneurs as well as accounting firms in the Netherlands. SnelStart is used by over 125.000 Dutch companies.

  • SQL Server Power Query connector

    Also known by the name: Microsoft SQL Server.

    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 accessible with the SQL Server Power Query connector.

  • StackOverflow Power Query connector

    Also known by the name: StackExchange.

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

    Tables accessible with the StackOverflow Power Query connector.

  • Sugar CRM Power Query connector

    Sugar CRM is online software for customer relationship management (CRM).

  • Teamleader Focus Power Query connector

    Also known by the name: Teamleader.

    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 Power Query connector provides access to 243 tables of data.

  • Teradata Power Query connector

    Also known by the name: NCR Teradata.

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

  • Tixly Power Query connector

    Also known by the name: Tix.

    Tixly is online software for leisure and entertainment management. Tixly is available globally.

  • Tweede Kamer (NL) Power Query connector

    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 accessible with the Tweede Kamer (NL) Power Query connector.

  • Twinfield Power Query connector

    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 Power Query connector provides access to 128 tables of data.

  • VirusTotal Power Query connector

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

    The VirusTotal Power Query connector provides access to 6 tables of data.

  • Visma EAccounting Power Query connector

    Visma eAccounting is cloud software for accounting. eAccounting is used by many small entrepreneurs.

    Tables accessible with the Visma EAccounting Power Query connector.

  • Visma Severa Power Query connector

    Also known by the name: Visma Project Management.

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

    The Visma Severa Power Query connector provides access to 263 tables of data.

  • Visma.net Financials Power Query connector

    Also known by the name: Visma.net.

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

    Tables accessible with the Visma.net Financials Power Query connector.

  • Wikipedia Power Query connector

    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 accessible with the Wikipedia Power Query connector.

  • WooCommerce Power Query connector

    WooCommerce is online shopping and e-commerce software that integrates into WordPress.

  • Xero Power Query connector

    Xero is online software for small and medium-sized companies. Xero is available in several English-speaking countries.

  • XML Audit File Afrekensystemen Power Query connector

    Also known by the name: XAA.

    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 accessible with the XML Audit File Afrekensystemen Power Query connector.

  • XML Audit File Financieel Power Query connector

    Also known by the name: XAF.

    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 Power Query connector provides access to 48 tables of data.

  • XML Audit File Salaris Power Query connector

    Also known by the name: XAS.

    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 Power Query connector provides access to 36 tables of data.

  • YouTrack Power Query connector

    Also known by the name: JetBrains YouTrack.

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

    The YouTrack Power Query connector provides access to 379 tables of data.

  • Yuki Power Query connector

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

    Tables accessible with the Yuki Power Query connector.

  • Zendesk Power Query connector

    Zendesk is online software for helpdesk, sales and customer interaction.

  • Zoom Power Query connector

    Zoom is video, phone and web conferencing software.

    The Zoom Power Query connector provides access to 194 tables of data.