Dashboards in minutes

Connect Sólides DP to Looqbox: Dashboards in Minutes

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

Connect Sólides DP to Looqbox

Connect your Sólides DP time tracking data directly to Looqbox using Kondado’s no-code platform. You can replicate employee attendance records and daily summaries on a configurable schedule, keeping your workforce analytics current without manual exports. Simply select your data endpoints, choose Looqbox as your visualization tool, and start building charts that help you manage labor costs and team productivity.

13
available pipelines
276
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

Setting up the connection takes just minutes and requires no technical expertise. Authorize your Sólides DP account, pick the specific pipelines containing your Daily Summary and Employees data, and let Kondado handle the automated replication. Your HR and operations teams can then explore overtime trends, track paid hours, and monitor attendance patterns directly in Looqbox to make faster staffing decisions and optimize workforce allocation across departments.

Kondado provides a direct connection between Sólides DP and Looqbox, allowing business teams to replicate attendance data and employee records on a configurable schedule without technical setup or intermediate databases.

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

Try out all the features for free for 14 days

Available data

Sólides DP data available in Looqbox

Each item below is automatically replicated by Kondado from Sólides DP into Looqbox — no schema setup, no manual mapping.

13
available pipelines
276
extractable fields
∞
Auto-refresh

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

With the Daily Summary and Employees pipelines available through Kondado, you can transform raw time clock data into actionable workforce intelligence in Looqbox. Visualize worked hours alongside employee admission dates to identify seasonal staffing trends, or track compensatory hours and holiday attendance to optimize shift scheduling. By combining job role information from the Employees pipeline with daily attendance metrics from Daily Summary records, managers can build custom reports that reveal productivity patterns across different teams and departments. This setup enables HR leaders to monitor paid hours trends and make data-driven decisions about hiring needs and resource allocation without waiting for IT support.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Looqbox

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Sólides DP Data Source

Add Sólides DP as a data source in Kondado by entering your account credentials to authorize access. Select the Daily Summary and Employees pipelines containing your attendance and workforce information.

2
Choose Looqbox Destination

Select Looqbox as your visualization destination and map the incoming Sólides DP fields to your preferred data structure. This establishes the automated flow between your time tracking system and reporting environment.

3
Build Dashboards and Set Schedule

Create custom attendance reports in Looqbox using your replicated Daily Summary and Employees data, then configure the refresh schedule to keep metrics updated automatically. Share these visualizations with your HR team to monitor worked hours and optimize workforce planning.

Access Sólides DP data in Looqbox and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Sólides DP data in other BI tools

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

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

Frequently Asked Questions (FAQ)

Answers about visualizing Sólides DP data in Looqbox automatically

How do I connect Sólides DP to Looqbox using Kondado? ▼
Start by adding Sólides DP as a data source in your Kondado account and authorize access to your time tracking data. Then select Looqbox as your destination, choose the Daily Summary and Employees pipelines you want to replicate, and set your preferred update frequency to begin automated data transfers.
What attendance KPIs can I track in Looqbox with Sólides DP data? ▼
You can monitor worked hours, paid hours, compensatory hours, and holiday attendance patterns using the Daily Summary pipeline. Combine this with employee birthdates and admission dates from the Employees pipeline to analyze tenure-related productivity trends or age demographics alongside attendance metrics.
How often does Sólides DP data update in Looqbox? ▼
Kondado replicates your Sólides DP data on a configurable schedule that you control, with options ranging from every 5 minutes to daily updates. This keeps your Looqbox dashboards current based on how frequently your team needs to review attendance and workforce metrics for decision-making.
Can I build a dashboard showing overtime and compensatory hours in Looqbox? ▼
Yes, using the Daily Summary pipeline you can create visualizations that track overtime trends and compensatory hour balances across teams. Filter by employee ID or job role to identify which departments accumulate the most extra hours, helping you optimize scheduling and labor budgets.
How do I create my first Sólides DP attendance dashboard in Looqbox? ▼
Start by dragging fields from your replicated Daily Summary and Employees data into Looqbox's visualization builder. You can combine worked hours, job roles, and admission dates to create custom charts that reveal workforce trends without any pre-configuration or technical setup.
How do I share Sólides DP attendance reports with my team in Looqbox? ▼
Once you build your dashboards in Looqbox, use the platform's native sharing features to distribute reports to managers and stakeholders. Your team will always see the latest attendance data since Kondado keeps the information updated automatically based on your configured schedule.
Can I combine Sólides DP data with other business data in Looqbox? ▼
Absolutely, you can send Sólides DP data to Looqbox alongside information from other sources such as PostgreSQL, MySQL, or Excel. This allows you to correlate employee attendance metrics with sales figures, project timelines, or financial data for comprehensive business analysis.

Try out all the features for free for 14 days