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:

  1. 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.
  2. 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 sourceDescription
Auth0Auth0 is a flexible, drop-in solution to add authentication and authorization services to your applications.
BigQueryBigQuery is a serverless and cost-effective enterprise data warehouse that works across clouds and scales with your data.
CockroachDBA distributed SQL database designed for speed, scale, and survival.
Google SheetsAn online spreadsheet editor from Google.
LookerYour unified business intelligence platform. Self-service. Governed. Embedded.
MetabaseAn open-source business intelligence platform.
MongoDBCross-platform document-oriented database.
MySQLAn open-source relational database management system.
PostgreSQLPostgreSQL 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.
QuickBooksAn online accounting software for small businesses.
SnowflakeData platform as a self-managed service.
RedshiftAmazon 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: