Custom connectors for Microsoft Azure Data Factory

The following connectors are available for use with Microsoft Azure Data Factory 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 Azure Data Factory, most people use the OData4 bridge to real-time retrieve the data directly into Microsoft Azure Data Factory. Each online connector provides support for downloading marketing and customer data, but also financial data into your data warehouse. Also, each Microsoft Azure Data Factory 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.

• ActiveCampaign

  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.

• 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.

• AutoTask

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

• Chargebee

  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.

• CIR

  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

  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

  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").

• Discourse

  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.

• DocumentCloud

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

• Dropbox

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

• Dummy

  Dummy is a sample database. The dummy contains data for English project-based companies. The data is relatively small in size and provides fast access due to an in-memory storage.

• Dynamics CRM

  Microsoft Dynamics CRM is cloud software for managing your customer activities such as sales and support cycles.

• Exact Online

  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.

• Facebook

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

• Freshdesk

  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.

• GitLab

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

• HTML

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

• IBM DB2 UDB

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

• JIRA

  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.

• JSON

  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

  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.

• Knack

  Knack is software to create online databases without coding.

• LinkedIn

  LinkedIn is an online social network for business use. LinkedIn enables information exchange between professionals globally.

• Logius COR

  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.

• Loket.nl

  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.

• Magento

  Magento is a webshop platform. Magento has a core product plus many partner-specific extensions.

• Mendix

  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

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

• MySQL

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

• NMBRS

  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.

• Octopus

  Octopus is cloud software for accounting. It synchronizes data from a Java client with the Octopus cloud storage. Octopus is mostly used by accounting firms in Belgium.

• OData

  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

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

• OpenSpending

  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.

• Oracle

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

• PayPal

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

• PostgreSQL

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

• RDW

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

• Robaws

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

• Roller

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

• RSS

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

• Salesforce

  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.

• Simplicate

  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.

• Slack

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

• Snelstart

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

• 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.

• StackOverflow

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

• Teamleader Focus

  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.

• Teradata

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

• Twinfield

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

• Twitter

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

• VirusTotal

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

• Visma EAccounting

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

• Visma Severa

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

• Visma.net Financials

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

• Wikipedia

  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.

• XML

  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

  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.

• XML Audit File Financieel

  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.

• XML Audit File Salaris

  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.

• Yuki

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

• Zoom

  Zoom is video, phone and web conferencing software.