No-code pipeline · Sólides DP → SQL Server

Send data from Sólides DP to SQL Server

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 SQL Server: managed, scheduled, no code.
Kondado replicates Sólides DP employee time clock and attendance data to SQL Server on a configurable schedule, including Daily Summary and Employees pipelines with 153 total fields available for analysis.

Replicate Sólides DP Data to SQL Server Automatically

Kondado connects Sólides DP directly to SQL Server, allowing you to replicate employee attendance and time tracking data without writing code. Configure your data source once, select which pipelines you need, and schedule automated updates to run every 5 minutes, hourly, or daily based on your business requirements. Your Sólides DP data flows directly into your SQL Server database where you can query it alongside other business data for comprehensive workforce analytics and reporting.

Once your data arrives in SQL Server, you can build custom attendance dashboards, calculate overtime costs, and correlate employee productivity metrics with operational KPIs. Combine Sólides DP time tracking data with sales figures from your CRM or financial data from your ERP to create unified reports that reveal labor efficiency patterns across your organization. This automated pipeline eliminates manual data exports and ensures your SQL Server always contains current workforce information for immediate decision-making.

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

Available Sólides DP Data in SQL Server

The Daily Summary pipeline delivers worked hours, paid hours, and compensatory hours directly to your SQL Server, enabling you to analyze attendance patterns and identify overtime trends across departments. You can track fields like isholiday and employeeid to calculate accurate payroll costs and monitor compliance with labor regulations. The Employees pipeline brings essential workforce data including admission dates, job roles, and birthdates into your database, allowing you to segment attendance analysis by tenure or position. Together, these pipelines let you build SQL queries that join time tracking data with employee demographics to uncover insights about productivity patterns and workforce scheduling efficiency.

Try out all the features for free for 14 days

Replicated to SQL Server

Sólides DP data available for SQL Server

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

13
available pipelines
276
extractable fields
SQL Server
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 SQL Server

Sync data automatically — no code, no manual exports.

1
Connect Sólides DP to Kondado

Authenticate your Sólides DP account in Kondado by providing your API credentials through the no-code interface. Select the employee time tracking data source to establish the initial connection and verify access to your attendance records.

2
Configure SQL Server Destination

Enter your SQL Server connection details including server address, database name, and authentication credentials to designate where your Sólides DP data should land. Test the connection to ensure Kondado can write the Daily Summary and Employees pipelines to your database successfully.

3
Select Pipelines and Schedule

Choose which Sólides DP pipelines you want to replicate, such as Daily Summary for attendance hours or Employees for workforce demographics, then set your preferred update frequency. Configure the schedule to run every 5 minutes, hourly, or daily to keep your SQL Server data current without manual intervention.

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 SQL Server automatically

How does Kondado replicate Sólides DP data to SQL Server? ▼
Kondado connects directly to your Sólides DP account and extracts employee time clock and attendance information through available pipelines. The platform loads this data into your SQL Server database on your chosen schedule, creating structured datasets that you can query immediately using standard SQL commands without any manual export processes.
What specific Sólides DP information can I replicate to SQL Server? ▼
You can replicate two main pipelines: Daily Summary containing worked hours, paid hours, compensatory hours, and holiday indicators, plus Employees data including names, emails, admission dates, job roles, and birthdates. These 153 available fields give you comprehensive workforce data for attendance tracking and HR analytics directly in your database.
How frequently can I update Sólides DP data in my SQL Server database? ▼
Kondado runs on a configurable schedule that you control, allowing updates every 5 minutes, 15 minutes, hourly, or daily depending on your reporting needs. This ensures your SQL Server contains current attendance data without overwhelming your system with unnecessary API calls or database writes.
Can I join Sólides DP data with information from other platforms in SQL Server? ▼
Yes, once Sólides DP data resides in SQL Server, you can write queries that combine employee attendance records with data from PostgreSQL, BigQuery, or other sources you have replicated. This allows you to correlate time tracking metrics with sales performance, project management data, or financial records stored in the same database.
What format does Sólides DP data take when it arrives in SQL Server? ▼
Kondado creates structured relational datasets in SQL Server that mirror your selected Sólides DP pipelines, with columns representing each available field like employeeid, worked hours, and admission dates. The data arrives ready for querying, joining with existing tables, or connecting to visualization tools like Power BI and Looker Studio.
Do I need technical coding skills to set up the Sólides DP SQL Server connection? ▼
No coding is required to establish the connection or configure your data replication schedule. Kondado provides a no-code interface where you authenticate your Sólides DP account, select your SQL Server destination, and choose which pipelines to replicate using point-and-click configuration.
Can I send Sólides DP data from SQL Server to Google Sheets or other tools? ▼
While Kondado replicates data from Sólides DP directly to SQL Server, you can also set up additional pipelines to send the same data to Google Sheets, Power BI, or BigQuery simultaneously. This lets you maintain SQL Server as your central warehouse while making specific datasets available in other tools for different teams.
Which SQL Server versions support Sólides DP data replication? ▼
Kondado works with multiple SQL Server editions and versions, loading data into standard relational structures compatible with SQL Server 2016 through 2022 as well as Azure SQL Database. The platform handles data type mapping automatically to ensure your Sólides DP fields translate correctly into appropriate SQL Server column formats.

Try out all the features for free for 14 days

Try out all the features for free for 14 days