Connect your RPMflex data to the other tools in your company

More analysis, integration and intelligence for better decisions. Take your operational data to Power BI, Excel, Artificial Intelligence and the systems your team already uses.

Secure accessRead-onlyYou stay in control of your data
See how it works
What is RPMsql

Your data. Your access. Your analysis.

RPMsql is a data repository exclusive to your company, with RPMflex information organized with clear names and a structure designed for analysis, with no risk of interfering with the operation of the system.

It is the direct path between your operational data and your everyday tools, with no intermediate spreadsheets and no need to depend on anyone to extract information.

How it works

From RPMflex to your analysis, with no manual steps

1

RPMflex

Your operation records customers, sales, finance, projects and much more.

2

Automatic synchronization

RPMflex data is replicated daily.

3

Exclusive repository

A database dedicated to your company, isolated and monitored.

4

Your tools

You connect through a VPN and analyze with the tool you prefer.

Available data

The complete operation, ready for analysis

The main RPMflex domains are published in your repository, with stable identifiers so you can cross-reference information between them.

Customers

  • Legal name, trade name, CNPJ/CPF (tax ID) and address
  • Segment, economic group, source and priority
  • Responsible representative and status
  • Phone numbers, email and website

Sales

  • Deals with value, expectation and funnel stage
  • Source, category, representative and contact
  • Forecast, submission, approval and lead time
  • Last activity and next follow-up

Finance

  • Debits and credits with due date, payment and status
  • Category, project, cost center and bank account
  • Withheld taxes: IRRF, PIS, COFINS, CSLL, ISS and INSS
  • Accrual period, document, installments and breakdowns

Projects

  • Customer, economic group, category, status and cost center
  • Project, quality and documentation managers
  • Planned start and end dates
  • Total tasks and open tasks
  • Hours (man-hours) and expenses: estimated vs. actual

Support

  • Tickets with customer, contract, requester and category
  • Status, priority, target date and resolution date
  • Department, owner and service monitor
  • Opened through the customer portal (iClient) or by the team
  • First-level and total SLA, and hours worked

Timesheet

  • Source of the entry: project, task or ticket, with customer and contract
  • Resource, category, type and activity description
  • Date, start, end, regular and extra hours
  • Selling and buying rate and amount per hour
  • Billable, billed, and link to accounts receivable and payable
In practice

What your company can do with RPMsql

Sales dashboard

Sales funnel by representative, segment and source in Power BI, updated every day.

Cash flow and delinquency

Project receipts and payments in Excel or Power BI by cross-referencing due dates, payments and status.

Natural-language questions with AI

Connect AI assistants and get answers in seconds.

Which customers in the Accounting segment have had no follow-up for 30 days?

Automatic alerts

Notices about invoices coming due, deals stalled in the funnel or overdue follow-ups.

Tax analysis and reconciliation

Withheld taxes organized by accrual period, ready for your accountant.

Cross-referencing with other sources

Combine RPMflex data with targets, budgets, other platforms or your data warehouse.

Compatible with any tool that connects to MariaDB/MySQL

  • Power BI
  • Excel (Power Query)
  • AI assistants
  • Python and R
  • DBeaver and HeidiSQL
  • Corporate BI and internal systems

Want to see RPMsql applied to your company's reality?

Security

Simple to use, strong in protection

The database is not exposed to the internet and all access goes through layers of protection.

Dedicated WireGuard VPN

Access only through an encrypted tunnel, with an individual key per user.

End-to-end encryption

TLS connections are mandatory between your tool and the repository.

Read-only user

Exclusive credential with no write permission: nothing is changed at the source.

Environment isolated per customer

Each company has its own instance, without sharing space with third parties.

Continuous monitoring

Audited synchronizations and infrastructure closely watched.

Frequently asked questions

Questions about RPMsql

What is RPMsql?

RPMsql is a read-only data repository exclusive to your company, with RPMflex information organized for analysis. With it, your team connects that data to Power BI, Excel, Artificial Intelligence assistants and other systems.

Do I need to be an RPMflex customer to sign up for RPMsql?

Yes. RPMsql is a complementary solution to RPMflex: it makes available the data your company already records in the ERP.

Which RPMflex data is available?

Customers, sales, finance, projects, support and timesheet, with names in Portuguese and identifiers that allow you to cross-reference the information.

How often is the data updated?

Data is synchronized automatically once a day, with no manual exports.

Which tools can I connect to RPMsql?

Any tool compatible with MariaDB/MySQL databases, such as Power BI, Excel (Power Query), Python, R, DBeaver, HeidiSQL, corporate BI solutions and internal systems. It is also possible to connect AI assistants, such as ChatGPT, Claude, Google Gemini and Grok, among others, through database connectors.

Can RPMsql change or delete RPMflex data?

No. Access is made with a read-only user, through a dedicated VPN and an encrypted connection, in an environment isolated for each company.

Who builds the connections and analyses?

Your company's technical team or a partner of your choice, as long as they have SQL and database knowledge.

How much does RPMsql cost?

Prices and terms are provided by the RPMflex sales team. Reach out on WhatsApp (11) 92447-3562 or by email at comercial@rpmflex.com.

How to sign up

Ready to activate your RPMsql?

1

Request activation

Talk to our sales team to learn the prices and sign up.

2

Receive your credentials

Individual VPN profile and exclusive user, delivered securely.

3

Connect and analyze

Point your favorite tool at it and start exploring.