Skyvia can easily load data from all your cloud apps to a database or a cloud data warehouse. Then, it's easy to connect Pentaho to this data warehouse and perform the in-depth analysis you need.
All you need to do is to specify parameters for connecting to Pentaho and data warehouse and select which data to replicate.
Skyvia’s Replication Tool will painlessly ensure you always have the most current data from your cloud applications in your data warehouse.
You don’t need to prepare the database — Skyvia creates the tables, corresponding to the source objects, in the data warehouse automatically.
In many cases you may want to organize data in the warehouse differently than in a cloud application. You may want to create a schema for OLAP or simply have target tables for data already created. In this case you can use our data import tools. With powerful mapping settings and flexible configuration, our import allows loading data between data sources of different structure.Learn more about import
With Skyvia Connect you can easily create a no-coding OData API layer for your data and create live connections directly to your data via the OData protocol. Our OData server includes built-in security layer, advanced logging, and allows you to open access only to the required part of the source data.Learn more about connect