No-code pipeline · Sólides DP → BigQuery

Send data from Sólides DP to BigQuery

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

From Sólides DP to BigQuery: managed, scheduled, no code.
Kondado automatically replicates Sólides DP’s Daily Summary and Employees pipelines to BigQuery on a configurable schedule ranging from every 5 minutes to daily, enabling automated workforce analytics without manual data extraction.

Send Sólides DP Data to BigQuery Automatically

Kondado enables you to replicate your Sólides DP attendance and time tracking data directly into BigQuery without writing any code. Simply select your data source, authenticate your Sólides DP account, and choose which data pipelines you want to replicate. Your employee attendance records, work hours, and HR information will flow into your BigQuery data warehouse on a configurable schedule that matches your business needs, eliminating manual CSV exports and tedious data entry tasks.

Once your data arrives in BigQuery, you can combine Sólides DP workforce metrics with financial data from other sources to build comprehensive labor cost analyses and payroll verification reports. Create custom dashboards that track employee productivity, attendance patterns, and overtime trends using your preferred business intelligence tools such as Looker Studio or Power BI.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

The Daily Summary pipeline delivers worked hours, paid hours, and compensatory hours directly into your data warehouse, allowing you to analyze attendance patterns and labor costs across departments. Meanwhile, the Employees pipeline provides essential HR data including names, email addresses, and admission dates that enable you to track workforce composition changes over time.

With both pipelines active in BigQuery, you can correlate individual employee records with their daily attendance metrics to identify productivity trends, monitor overtime utilization, and verify payroll accuracy. This unified dataset supports advanced analytics such as calculating cost per project, predicting staffing needs based on historical patterns, and generating automated compliance reports for HR audits.

Try out all the features for free for 14 days

Replicated to BigQuery

Sólides DP data available for BigQuery

Tables Kondado writes into your BigQuery, on a schedule you control.

13
available pipelines
276
extractable fields
BigQuery
Destination

Available integrations

Daily Summary
Includes information such as worked hours, paid hours, and compensatory hours. Fields like id, employeeid, and isholiday help analyze employee attendance.
Employees
Contains data about employees, including name, email, and admission date. Fields like id, jobroledto__id, and birthdate provide essential details about each employee.
Time Clock Records
Employee clock-in and clock-out punches, one per row, with date and time, entry and exit geolocation, workplace, and adjustment and validation flags (fingerprint, facial recognition).
Time Adjustments (incl. vacations and leaves)
Time adjustments such as vacations, medical certificates, days off, and excused absences. Each row has the period, reason, employee, and approval status, useful for tracking justified absences.
Adjustment Reasons (incl. vacations and leaves)
Registered adjustment reasons, such as vacation, medical certificate, day off, and excused absence. This is the table that classifies time adjustments.
Job Roles
Company job roles, with description, CBO (Brazilian occupation code), and base salary.
Work Schedules
Registered work schedules (shifts), one per row, to compare the planned workday with the recorded hours.
Workplaces
Workplaces (departments and units), active and inactive, to analyze attendance and hours by unit.
Managers
Registered managers and their matching employee record, to build attendance analysis by team and leadership.
Companies (branches)
Registered companies (headquarters and branches, by CNPJ). Employees point to their company through the company__id field, so attendance and hours can be analyzed by branch.
Time Clock Rules
Registered time clock rules: tolerances, night hours, hour bank vs. overtime control, and hour bank percentages and limits.
Hour Bank (current balance)
Current hour bank balance for each employee at read time. The table is rewritten on every run, as a snapshot of the balance, without history.
Time Edit Justifications
Justifications available for manually editing clock punches, with the attachment and note requirements of each one.

Try out all the features for free for 14 days

How to send Sólides DP data to BigQuery

Sync data automatically — no code, no manual exports.

1
Connect Sólides DP Account

Authenticate your Sólides DP data source by entering your API credentials in Kondado's interface to establish the initial connection.

2
Configure BigQuery Destination

Specify your BigQuery project and dataset details where the Sólides DP data will be stored, ensuring proper permissions for data loading.

3
Select Pipelines and Schedule

Choose the Daily Summary and Employees pipelines you want to replicate, then set your preferred update frequency from every 5 minutes to daily.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Send data from Sólides DP to other destinations

Choose a tool to visualize your Sólides DP data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Answers about sending Sólides DP data to BigQuery automatically

How does Kondado replicate Sólides DP data to BigQuery? ▼
Kondado connects directly to your Sólides DP account to extract data from your selected pipelines. The platform then loads this information into your specified BigQuery dataset on your chosen schedule, maintaining data consistency without requiring manual exports or technical infrastructure.
What specific Sólides DP data can I replicate to BigQuery? ▼
You can replicate two main pipelines: the Daily Summary pipeline containing worked hours, paid hours, compensatory hours, and holiday indicators, plus the Employees pipeline with names, email addresses, job roles, and admission dates. Together these provide 153 fields covering attendance tracking and workforce demographics for comprehensive HR analytics.
How often does Sólides DP data update in BigQuery? ▼
Kondado updates your Sólides DP data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This near-real-time capability ensures your workforce analytics reflect current attendance patterns while balancing BigQuery processing costs against your reporting urgency.
What format does Sólides DP data take in BigQuery? ▼
Sólides DP data loads into BigQuery maintaining its original structure and data types, making fields like employee IDs, timestamps, and numerical hours immediately queryable using standard SQL. Each pipeline becomes a distinct dataset that you can join with other business data or visualize in tools like Looker Studio.
Can I combine Sólides DP data with other sources in BigQuery? ▼
Absolutely, BigQuery serves as a central repository where Sólides DP workforce data can be joined with financial information from PostgreSQL or sales metrics from other platforms. This enables cross-functional analysis such as correlating labor costs with revenue or matching employee attendance against project timelines stored in your data warehouse.
Do I need coding skills to send Sólides DP data to BigQuery? ▼
No coding is required to establish the connection or maintain ongoing data replication between Sólides DP and BigQuery. Kondado provides a visual interface where you authenticate your account, select your desired pipelines, and configure your update schedule through simple dropdown menus.

Try out all the features for free for 14 days

Try out all the features for free for 14 days