Via data sync connectors
Zenskar connects with your data source, such as a database, data warehouse, comma-separated-value file, or spreadsheet.
Zenskar's data-source-specific connectors
Zenskar uses data-source-specific connectors to connect with your data sources and ingest data.
Engineering effort required
The details needed for this step are source-type dependent. Therefore, some technical knowledge is expected to complete this step.
To set up a connector, do the following:
- Set Up Source: Provide a Source Name and select a Source Type from the drop-down. The list of available Zenskar connectors is given below.
- Source Config: Provide credentials and other configuration details to establish a connection with the data source. Refer the documentation of the connector you are interested in to know the configuration details.
Note
Irrespective of the data source type, Zenkar stores all ingested data in the form of RDBMS tables.
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet.
Zenskar connectors
| Data source | Description |
|---|---|
| Auth0 | Auth0 is a flexible, drop-in solution to add authentication and authorization services to your applications. |
| BigQuery | BigQuery is a serverless and cost-effective enterprise data warehouse that works across clouds and scales with your data. |
| CockroachDB | A distributed SQL database designed for speed, scale, and survival. |
| Google Sheets | An online spreadsheet editor from Google. |
| Looker | Your unified business intelligence platform. Self-service. Governed. Embedded. |
| Metabase | An open-source business intelligence platform. |
| MongoDB | Cross-platform document-oriented database. |
| MySQL | An open-source relational database management system. |
| PostgreSQL | PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. |
| QuickBooks | An online accounting software for small businesses. |
| Snowflake | Data platform as a self-managed service. |
| Redshift | Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. |
👍 Pros and 👎 cons
| 👍 Pros | 👎 Cons |
|---|---|
| No engineering bandwidth is required for integrating Zenskar with your system. | Initial data sync can take some time, depending on the size of the data. |
| Invoices can be generated quickly. | Data-ingestion frequency depends on the sync schedule. This does not matter if you are only interested in periodic billing. |
| Zenskar allows you to edit usage data that has been synced. | Viewing usage data is not supported. |
Note
If data ingestion via Zenskar's data-source connectors does not suit your needs, you may look at the following options:
Updated 7 days ago