DXtrade Data Replication Push Service to MySQL – Devexperts DXtrade Reporting Server Alternative

WE ❤️ DEVELOPERS!

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, category, etc.
• Symbols: shows Curency, lot size, pip size, description, etc
• Order-Executions: Contains live price data synchronized from the DXtrade server: Columns include: id, symbol, buy_value, sell_value, spread, markup, etc.
• Positions: 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 general account details: Columns include: Base currency, Status, Account type, etc
• Users: Provides access to personal details: Login username, email, name, etc
• Account-metrics: Provides access to financial details: Columns include: Balance, Free Margin, Margin, Trade count, etc
• Daily Reports: Provides end-of-day summaries of trading activity: Columns include: id, report_date, total_volume, end of day balance, profit, active_users, closed_positions, etc.
• In addition Kenmore Design will add any data-points required for your project.

Synchronization Workflow:

• Data Pull: The service periodically initiates API calls to the DXtrade server, either at predefined intervals or triggered by the server, to fetch updates on trades, users, equity, and other relevant tables.
• Data Transformation and Validation: Retrieved data is transformed to align with the local database schema. Validation processes ensure data consistency, flagging or removing any anomalies.
• Database Updates: The validated data is inserted or updated in the local database, maintaining an accurate mirror of the DXtrade server.
• Synchronization Speed: The sync speed varies depending on factors such as trading server limitations, network throughput, geographical distances, and specific client requirements. For example, Equity values can be updated faster than User information.
• Post-Disconnect catch up: In the event of a lost connection to the database or trading server, the system retrieves historical data to re-sync any missed updates.
• Logging: Detailed logs are maintained to assist with troubleshooting.
• Notifications: The system supports critical notifications, which can be sent to a Slack channel or delivered via webhooks for specific events.

Get access to documentation and consultation for the DXtrade Data Push

Expert knowledge, replication push service details, documentation, pricing, guides, resources, and tools.

Get started

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.