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: