invantive documentation
Invantive SupportforenAnmelden / Eintragen

Invantive Bridge Online

Invantive Bridge Online makes the data of a database on Invantive Cloud available to other software over a standard protocol, so that a reporting tool, a spreadsheet or a data platform can read from over 100 platforms without knowing anything about them.

It is the counterpart of Invantive App Online: Bridge Online specialises in downloads, App Online in running application logic.

Highlights

Invantive Bridge Online offers:

  • OData version 4 as the protocol, which Microsoft Power BI, Microsoft Excel and many other tools speak natively.
  • Access to over 100 database and cloud platforms through Invantive UniversalSQL.
  • Metadata describing the tables and columns offered, so a tool can discover what is available.
  • Caching, so a repeated download does not repeat the load on the platform.
  • Fair use daily limits, which keep one heavy user from spoiling the service for the rest.
  • APIs for uses beyond the protocols; see the Bridge Online APIs.

Unterstützte Plattformen

Invantive Bridge Online is a service and needs nothing installed. Any client which speaks OData version 4 can use it.

Konfiguration

The databases offered are those defined on Invantive Cloud. What a client sees is decided there, per database.

Themen

The following topics cover typical use:

  • OData 4: the protocol offered, its addresses, authentication, answers and errors;
  • Supported OData 4 Features: which parts of the OData version 4 standard are read and which are not;
  • Examples: one worked example per shape of request, from a plain download to a grouping with totals;
  • Metadata: how the tables and columns are described;
  • Fair Use Limits: the daily limits and how to stay within them.

Questions and community knowledge can be found on forums.invantive.com.

Anmerkungen zu dieser Version