invantive

control

Manage your business with Microsoft Excel and Visma

Invantive Control is an Excel add-in for Visma. It's proven real-time reporting software which helps you to rethink and optimize your business from within Microsoft Excel. Using Excel formulas, Excel array formulas and blocks of data you easily retrieve information from Visma and you can even upload information from within Excel. You can use Pivot tables and charts based upon the data retrieved.

Invantive Control provides you with all the functionalities needed to make real-time business decisions. With the Excel add-in Invantive Control and Visma you will have all the functionalities you need to control your sales, custom relations management and service in real-time.

To log on: use the Visma credentials.

Invantive Control supports more than 50 other data platforms and applications, such as Visma, Teamleader, Exact Online, Dropbox, LinkedIn, Magento webshop and many more.

"The Terms of Service" are displayed on first use for acceptance.

Your business in control

The All Cloud Edition of Invantive Control provides you with benefits such as:

  • Flexibility of Excel by an Excel add-in paired with the data integrity provided by Visma in the cloud.
  • Download facts from from Visma using an Excel add-in.
  • Real-time data from Visma using Excel formulas, array formulas and data blocks.
  • Design and edit custom reports as spreadsheets based upon Visma.
  • Create and execute analytical models from within Microsoft Excel.

Samples

invantive

composition

Create documents with data from Visma in Microsoft Word

Manually collecting data and making tables in Word usually takes a very long time. Mainly in the case of regularly needed documents, this can be a very time consuming task. Invantive Composition offers a great solution to this problem. Invantive Composition helps you to select and retrieve data and tables from the Visma database with ease.

You can specify which information and data you are interested in from the rich APIs. Invantive Composition for Word will fill your previously created Word templates with data coming directly from the Visma database. Creating complex and correct Word documents containing all the specific information from Visma is now just a matter of a few minutes and has never been easier.

Invantive Composition for Word does not require a programmer. With Invantive Composition it is simple to fill out a Word template with Visma data. The resulting filled-out Word documents can be used without the application.

To log on: use the Visma credentials.

Invantive Composition for Word supports more than 50 other data platforms and applications, such as Visma, Teamleader, Exact Online, Dropbox, LinkedIn, Facebook, Microsoft ODBC and many more.

"The Terms of Service" are displayed on first use for acceptance.

The All Cloud Edition of Invantive Composition provides you with benefits such as:

  • Optimization of the document creation and communication process.
  • Automatically fill pre-composed templates in Word.
  • Focus on your customer support business, not on technology; no programming and no software developers.
  • Easily use and manage large volumes of templates.
  • Design and edit different documents based upon Visma.

Samples

invantive

query tool

Free real-time Business Intelligence for Visma using the Invantive Query Tool

Invantive's free SQL Query Tool for Visma provides you with real-time Business Intelligence across your entire business. It provides access to your crucial company information stored in the Visma cloud. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have. This enables you to organize your business data fast for correct decision making. You are be able to extract, analyze and to a certain extent report business data such as sales, prospects, tickets and customer data.

The Invantive Query Tool provides all the functionalities needed to make the right business decisions based upon your business data in the Visma cloud.

To log on: use the Visma credentials.

More than 50 data other platforms and applications are available for use with Invantive Query Tool, such as Visma, Teamleader, Exact Online, Dropbox, LinkedIn, Facebook and many more.

"The Terms of Service" are displayed on first use for acceptance.

The Invantive SQL drivers for Open Data platforms and on-premise databases have no restrictions. The drivers for other platforms, including Visma, are restricted to retrieve at most 100 rows on a detail level per query. The full drivers are available on subscription-based products.

SQL Query of business data in Visma

The All Cloud Edition of Invantive Query Tool provides you with benefits such as:

  • Flexibility of SQL paired with the data provided by Visma.
  • Download facts into SQL query tool such as tickets from Visma using queries.
  • Real-time customer relations management and business intelligence.
  • Re-use existing SQL knowledge without learning API protocols and/or coding.
  • Develop and run SQL statements.

Samples

invantive

online SQL editor

Manage your company with Visma and the web-based Online SQL Editor

Invantive's free Online SQL Editor for Visma provides you with real-time business knowledge across your entire enterprise. It provides access to your crucial company information stored in Visma. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have. This enables you to analyze your business data fast for correct decision making. You are be able to extract and analyze business data such as tickets and customer data.

It doesn't matter where you are; you can login from any location via the web browser and retrieve tickets, contacts and all other information available through APIs using SQL. The Online SQL Editor provides all the functionalities needed to make business decisions using your smart phone, iPad, iMac or PC.

To log on: use the Visma credentials.

"The Terms of Service" are displayed on first use for acceptance.

The Invantive SQL drivers for Open Data platforms and on-premise databases have no restrictions. The drivers for other platforms, including Visma, Teamleader, are restricted to retrieve at most 100 rows on a detail level per query. The full drivers are available on subscription-based products.

SQL Query of business data in Visma

The Visma Edition of the Online SQL Editor provides you with benefits such as:

  • Interactive and online access to your company information via any modern web browser.
  • Usable from any location and any platform, such as Windows, Mac, Linux, iPhone, iPad etc.
  • Connect directly with cloud platforms with the same credentials as you normally use.
  • All Visma APIs accessible.

Samples

invantive

bridge

Connect your applications using proven Invantive technology and ADO.NET

Invantive Bridge is an SDK that enables your applications and databases to connect using the same technical features as offered by the range of Invantive products. Invantive Bridge provides cloud connectivity as well as an advanced SQL engine and drivers. With Invantive Bridge you can access your cloud and on-premise applications and data from within Microsoft Visual Studio, Microsoft Power BI, Telerik and many others using familiar SQL statements and Microsoft ADO.NET.

The use of the cloud connectivity options of Invantive Bridge allows you to use a wealth of connection options to combine applications, processes and data across the cloud into one connected solution.

To log on: use the Visma credentials.

The advanced Invantive SQL engine within the SDK enables your solutions to offer an easy reporting and analysis environment independent of and in addition to the connectivity protocols already available. Both 32 and 64 bit drivers are supported.

Connections are available to over 50 other platforms in combination with Visma. Some connectors such as traditional database drivers require additional licenses and/or software.

"The Terms of Service" are displayed on first use for acceptance.

An easy reporting and analysis environment thanks to the Invantive SQL engine within the SDK

Invantive Bridge offers you benefits such as:

  • Cloud-connectivity.
  • Microsoft Power BI and Visual Studio.
  • Microsoft ADO.NET driver.
  • Advanced Invantive SQL engine.
  • Large number of possible on-premise and cloud platforms.

Samples

invantive

data hub

Controlled and timed data exchange for Visma

The All Cloud Edition of Invantive Data Hub is command-line driven software that is capable of executing Invantive scripting language compatible scripts across many database and cloud platforms. Ideal for high volume data loads into and extractions of Visma. It provides a headless mode which makes it ideal for use in server environments and scheduled uploads and downloads in lights-out operations.

Thanks to compatibility with the popular Invantive scripting language, you can easily move business processes you have designed on Invantive Control for Excel or Invantive Query Tool into a server environment. Besides high volume data loads you can also generate reports in Excel and other formats using data from Visma.

The support for headless mode enables Invantive Data Hub to be started by batch files or from the Windows Task Scheduler. When running Invantive Data Hub in headless mode, you will enjoy the integrated logging features for ease of analysis and auditability.

To log on: use the Visma credentials.

The All Cloud edition has cross-database capabilities to over 50 on-premise and cloud platforms.

"The Terms of Service" are displayed on first use for acceptance.

Supercharge data exchange with Visma

The All Cloud Edition of Invantive Data Hub provides you with benefits such as:

  • Schedule and run high volume data loads and extractions of Visma.
  • Headless and command-line driven for use on servers.
  • Invantive Query Tool-scripting language compatible.
  • Share reports in PDF, SQL, CSV, Excel and XPS formats to network shares or DropBox.
  • Direct distributed SQL statements and replication between over 50 platforms.

Samples

invantive

data replicator

Replicate data from Visma in a relational database

Invantive Data Replicator allows you to replicate data from Visma and over 50 other platforms in a relational database such as Microsoft SQL Server or PostgreSQL. Invantive Data Replicator ensures the presence of sufficiently "fresh" data for your reporting purposes by applying a combination of techniques, including near real-time synchronization using webhooks (where available and supported).

The replicated data is made available through configurable views, including consolidation across multiple companies such as with Visma, Teamleader, Exact Online and Nmbrs. Effectively you get a so-called "ODS" (Operational Data Store). The performance gain compared with repeatedly accessing the XML and REST APIs of Visma is between 50 and 2.500.

These database views can be used in your Power BI reports, Microsoft Access, custom reports and from traditional SQL. Data Replicator also automatically maintains indexes for optimal performance even with very large data sets and ad-hoc queries.

The advanced Invantive SQL engine included with Invantive Data Replicator enables you to configure the cloud sources for Data Replicator and trigger downloads. Data Replicator also includes Invantive Data Hub and Invantive Data Cache, so you can also run ad-hoc queries directly on over 50 cloud platforms, including cross-company and cross-country queries and uploads in Visma.

To log on: use the Visma credentials.

Data Replicator runs on 32 and 64 bit Windows devices.

"The Terms of Service" are displayed on first use for acceptance.

  • The first subscription period includes 1 hour of Getting Started consultancy.
  • Subscription per 100 companies.
  • Support available 9:00-17:00 CET through phone +31 88 00 26 599 or support@invantive.com.

Replicate your Visma data with Invantive Data Replicator

The All Cloud Edition of Invantive Data Replicator provides the following benefits to optimize your business processes:

  • Replication ensures use of fresh data.
  • Fresh data using a combination of techniques.
  • Consolidation into one reporting environment.
  • Runs on inexpensive PostgreSQL and Microsoft SQL Server databases.
  • Over 50 supported on-premise and cloud platforms.

Samples

invantive

data loader

Load data into cloud applications and relational databases

Invantive Data Loader transports data between Visma, cloud applications, relational databases and files in one integrated solution. Based upon Invantive SQL with it's dozens of connectors, you can easily load data into your cloud application or relational database using a graphical user interface.

For instance, Invantive Data Loader guides you through the exchanging data with Visma and many other platforms with a few clicks. It can take data from over 50 platforms such as Visma, Microsoft SQL Server, PostgreSQL, Teamleader, Exact Online, Freshdesk or CSV or Excel files.

The integrated advanced Invantive SQL engine provides a proven base for you to exchange data, including the use of fast bulk loaders on supported platforms such as Microsoft SQL Server. A flexible mapping of fields enables basic transformations during the process, while the flexibility of Invantive SQL on the background ensures that no tasks is too hard to accomplish.

The free version of Invantive Data Loader is restricted to at most 1.000 rows per run. For high volume use or background processing, please consider the use of compatible enterprise solutions such as Invantive Data Hub or Invantive Control. An unlimited use variant is included in these solutions.

Samples

Invantive

Office for Teams

Save money with the Office apps for teams

With Invantive Office for Teams you have a complete software suite to optimalize your business processes and to gain insight in your financial risks.

The software suite contains the following Invantive products:

  • Invantive Control for Excel
  • Invantive Composition for Word
  • Invantive Bridge for Power BI
  • Invantive Query Tool (Premium)
  • Invantive Business (Premium)
  • All Cloud drivers
  • Invantive SQL, Invantive Script and Invantive PSQL
  • Invantive Web Service
  • Invantive Data Cache

Invantive Control provides you with all the information needed to make real-time management decisions. In addition Invantive Control empowers you to create, secure and share (Qlikview, Power BI) detailed Excel models and reports in Microsoft Excel.

Invantive Composition for Word is a addin for Word. You can fill automatically pre-composed templates with data from Visma. By the automatic generation of complex documents, you have the solution to optimize your documentation and communication process.

With the cloud-connectivity provided by Invantive Bridge, you have within an integrated solution a wealth of connection options to combine applications, processes and data over the cloud.

Invantive Query Tool provides you with real-time Business Intelligence across your entire enterprise.

Invantive Business enables you to run your Visma business processes on Microsoft Windows.

Invantive's custom SQL parcel and processing engine is a feature-rich set of SQL statements that allows you to reuse SQL statements across databases and (cloud) applications.

The Invantive Web Service allows you to cloud-enable existing user applications, allowing access to enterprise systems and databases across the internet and the corporate network.

With Invantive Data Cache Cache you can place data from Visma and other connectors into a relational database for use by Invantive SQL. This requires an on-premise or cloud database of SQL Server or PostgreSQL.

The software is connected to more than 50 data platforms and applications. You can find a connectors list on https://www.invantive.com/products/invantive-sql/providerlist.

More detailed information about the products can be found on this website by clicking the individual products.

You can subscribe on Invantive Office for Teams. The price is € 100,00 per max. 5 users per month. This includes max. 5 partitions, like Exact Online administrations, Salesforce org, Freshdesk etc. Each additional user above the maximum of 5 in a month costs EUR 20,00; each additional partitions hit above the maximum of 5 in a month also costs EUR 5,00.

Your benefits:

  • Complete software suite for teams
  • Maximum of 5 partitions.
  • No programming.
  • Large amount of on-premise and cloud platforms connected.

Samples

Invantive

Office for Workgroups

Save money with the Office apps for workgroups

With Invantive Office for Workgroups you have a complete software suite to optimalize your business processes and to gain insight in your financial risks.

The software suite contains the following Invantive products:

  • Invantive Control for Excel
  • Invantive Composition for Word
  • Invantive Bridge for Power BI
  • Invantive Query Tool (Premium)
  • Invantive Business (Premium)
  • All Cloud drivers
  • Invantive SQL, Invantive Script and Invantive PSQL
  • Invantive Web Service
  • Invantive Data Cache

Invantive Control provides you with all the information needed to make real-time management decisions. In addition Invantive Control empowers you to create, secure and share (Qlikview, Power BI) detailed Excel models and reports in Microsoft Excel.

Invantive Composition for Word is a addin for Word. You can fill automatically pre-composed templates with data from Visma. By the automatic generation of complex documents, you have the solution to optimize your documentation and communication process.

With the cloud-connectivity provided by Invantive Bridge, you have within an integrated solution a wealth of connection options to combine applications, processes and data over the cloud.

Invantive Query Tool provides you with real-time Business Intelligence across your entire enterprise.

Invantive Business enables you to run your Visma business processes on Microsoft Windows.

Invantive's custom SQL parcel and processing engine is a feature-rich set of SQL statements that allows you to reuse SQL statements across databases and (cloud) applications.

The Invantive Web Service allows you to cloud-enable existing user applications, allowing access to enterprise systems and databases across the internet and the corporate network.

With Invantive Data Cache Cache you can place data from Visma and other connectors into a relational database for use by Invantive SQL. This requires an on-premise or cloud database of SQL Server or PostgreSQL.

The software is connected to more than 50 data platforms and applications. You can find a connectors list on https://www.invantive.com/products/invantive-sql/providerlist.

More detailed information about the products can be found on this website by clicking the individual products.

You can subscribe on Invantive Office for Workgroups. The price is € 200,00 per max. 10 users per month. This includes max. 10 partitions, like Exact Online administrations, Salesforce org, Freshdesk etc. Each additional user above the maximum of 10 in a month costs EUR 20,00; each additional partitions hit above the maximum of 10 in a month also costs EUR 5,00.

Your benefits:

  • Complete software suite for workgroups
  • Maximum of 10 partitions.
  • No programming.
  • Large amount of on-premise and cloud platforms connected.

Samples

Invantive

Business for Outlook

Easily access to your business data in Visma

Save money by combining Microsoft Word documents with data form Visma.

You have spent numerous hours to organize, clean and improve your business data in Visma. Invantive Business for Microsoft Outlook leverages this incredible power of your business data in Visma. Through a deep integration with Microsoft Outlook, you can easily access your business data in Visma.

To get started, click in the Download section on 'One-Click Install' to download Invantive Business for Outlook.

Samples

Invantive

Business for Windows

Run your Visma business processes on Microsoft Windows

Invantive Business enables you to run your Visma business processes on Microsoft Windows. This allows on-premises extensions and customizations for a better fit to your business. Also, Invantive Business allows you in an enterprise environment to reduce training costs and improve business processes by consolidating the use of multiple similar applications behind one frontend.

The one-size-fits-all approach of Visma eases implementation and reduces pricing levels at the cost of reduced flexibility to adapt the software to different business processes. However, the additional labor costs to compensate the missing flexibility can outweigh the reduced costs as compared to traditional on-premises solutions. With Invantive Business you can easily extend Vismar by using Invantive Business as a frontend to cloud applications and use the enterprise-features of Invantive Business to add additional functionality and integrations to Visma. Such additional functionality can be additional forms, reports, downloads or integrations.

In enterprise environments, it is not uncommon to find multiple applications of different vendors or versions to provide similar functionality across multiple companies owned. For instance, one company uses Microsoft CRM whereas another one runs Visma. In such situations, Invantive Business can be configured such that it real-time integrates all similar data across multiple applications into one consolidated enterprise-wide view. For instance, Invantive Business allows you to retrieve all customers from both Microsoft CRM as Visma in one overview.

To get started, click on the 'One-Click Install' button to download Invantive Business.

Your benefits:

  • Real-time consolidate data across multiple applications into one view.
  • Leverage existing skills.
  • Reduce training costs for new applications.

Samples

invantive

data access point

Cross-protocol data exchange across many platforms

Invantive Data Access Point is both online and on-premises software that allows exchanging data across various communication protocols. Invantive Data Access Point acts as a proxy that based upon legacy and/or Invantive SQL statements exchanges data using ten protocols such as RSS, XML or JSON even when the backend database and/or (cloud) application does not support the requested protocol.

Simplify integration and orchestration

Invantive Data Access Point provides the following benefits to optimize your business processes:

  • Simplify business process automation by simplified integration and orchestration.
  • Extend your existing databases and (cloud) applications by support for many additional communication protocols.
  • Reuse existing legacy and/or Invantive SQL statements to specify data downloads and uploads.

Samples

Invantive

get my report

Realtime reporting from PC, Mac, smartphone and tablet

Get My Report is an app to real-time retrieve reports from cloud applications such as Visma. From your PC, smartphone or tablet you can easily log on and retrieve data in various formats such as Excel.

Besides a number of standard reports, we can cost-effectively develop and deploy your custom reports in the layout and format you desire.

Please contact us for more information.

Your benefits:

  • Real-time reporting from cloud applications.
  • From PC, smartphone, tablet or Mac.
  • Supports more than 50 data platforms and applications.

Samples

Invantive® BV
  • Biesteweg 11
  • 3849 RD Hierden
  • the Netherlands
  • Bank: IBAN NL 42 RABO 01 23 4097 80, BIC RABO NL 2U.
  • PayPal: sales@invantive.com
  • Rabobank Groep N.V., Branch: Rabobank Peel, Maas en Leudal.
  • Sint Antoniusstraat 40, 6093 GC, Heythuysen the Netherlands