DXTrade Data Push
The DXtrade Synchronization Service is designed for brokers, marketers, and developers who need efficient, local access to DXtrade data for various applications.
DXtrade Data Replication Push Service to MySQL – Devexperts DXtrade Reporting Server Alternative
The DXtrade Synchronization Service is designed for brokers, marketers, and developers who need efficient, local access to DXtrade data for various applications.
Brokers can use the service to create customized reports that allow them to track client activity, analyze trading data, and gain business-specific insights.
Developers can access this data to create custom referral and IB payout systems, build Forex risk management applications, integrate Forex Marketing Suites, implement custom triggers for Prop firms, and more.
The web service acts as a middleware layer between a DXtrade trading server and a MySQL database, retrieving and processing live trading data from the DXtrade server to maintain an up-to-date mirror in the local database. This enables reporting, analysis, and operational monitoring.
DXtrade Reporting Server Alternative includes:
- DXtrade Manager API Connector: This module establishes a connection with the DXtrade server via the Manager API, enabling secure authentication to access trading data and manage accounts.
- Data Synchronization Service: A real-time service responsible for fetching data from the DXtrade server and keeping the local database synchronized.
- Data Transformer: This component formats and organizes raw data from the DXtrade server to align with the local database schema, ensuring consistency across the relevant tables.
Database Schema and Table Details:
- Groups: Stores user groups and associated trading permissions: Columns include: id, group_name, currency, markup, permissions, max_leverage, etc.
- Symbols: Contains live price data synchronized from the Match-Trader server: Columns include: id, symbol, buy_value, sell_value, spread, markup, etc.
- Timezone: Keeps track of the server’s current time and timezone: Columns include: id, server_time, timezone_offset, timezone_name.
- Positions-open: Stores all trades for each user: Columns include: id, user_id, position_type, symbol, price_open, price_close, volume, timestamp_open, timestamp_close, etc.
- Positions-closed: Stores all trades for each user: Columns include: id, user_id, position_type, symbol, price_open, price_close, volume, timestamp_open, timestamp_close, etc.
- Trading-Accounts: Holds client data with personal and trading account details: Columns: id, username, email, group_id, address, registration_date, account_status, etc.
- Accounts: Provides access to financial details: Columns include: Balance, Equity, Margin, etc
- Equity: Contains equity data for each user: Columns include: id, user_id, live_equity, highest_equity, lowest_equity, timestamp.
- Daily Reports: Provides end-of-day summaries of trading activity: Columns include: id, report_date, total_volume, balance, active_users, closed_positions, etc.
- Account-metrics: Provides access to financial details: Columns include: Balance, Free Margin, Margin, Trade count, etc
- In addition Octalas Group will add any data-points required for your project.
Synchronization Workflow:
- Data Pull: The service initiates API calls to the Match-Trader server at set intervals or following the server pre-defined API retrieving data changes across trades, users, equity, and other pertinent tables.
- Data Transformation and Validation: Incoming data is transformed to fit the local schema. Additional validation ensures data consistency, removing or flagging any anomalies.
- Database Update: The processed data is inserted or updated in the local database, maintaining a mirrored state of the Match-Trader server.
- Synchronization Speed: In general the sync speed varies. It depends on the Trading server limitations, geographical distances, network throughput, and general requirement of the client. It is possible to synchronize Equity values faster than updating User info for example.
- Post-Disconnect catch up: In case the connection with database or trading server is lost the server will go back in time and will catch up/re-sync missing data updates.
- Logs: the system keeps logs for troubleshooting.
- Notifications: The system can post critical notification to a Slack channel or provide web-hooks for events.
Get access to documentation and consultation for the DXtrade Data Push
Expert knowledge, replication push service details, documentation, pricing, guides, resources, and tools.
Choose DXtrade PUSH Database Replication Service for hassle-free data access with no per-use or usage limitations — all for a simple flat monthly fee. With over 15 years of expertise and a reputation for reliability, we’re the trusted choice to keep your business data effortlessly synchronized and ready to power your custom applications and reports.
Let’s Collaborate with Us!
From an early stage start-up’s growth strategies to helping existing businesses, we have done it all! The results speak for themselves. Our services work.
