MySQL / ODBC Developer Needed to Rebuild Small Windows-to-Ubuntu Database Bridge

Job Details

Description

We are looking for an experienced database/integration developer to recreate a small legacy data bridge between a Windows PC connected to our manufacturing ERP through ODBC and an existing Ubuntu/MySQL/PHP application. This is not a full application rebuild. The existing Ubuntu application is operational. We need to replace a missing Windows-side extraction/bridge process that previously transferred sales order data into two MySQL staging tables. Current Environment Source Windows PC Proprietary manufacturing/ERP system Transoft ODBC / MC Connect interface Working ODBC DSN already configured We have successfully queried live ERP data through Excel/Microsoft Query Destination Ubuntu server MySQL 5.5 Existing PHP application Existing MySQL staging tables: none_SOHEAD none_SOLINE The existing Ubuntu application reads those staging tables and handles the downstream production-order processing. What We Have Already Confirmed We can successfully query both source ERP tables through ODBC: SOHEAD — sales order headers SOLINE — sales order line items We tested a current sales order and successfully retrieved the correct SOHEAD record and all six corresponding SOLINE records. The source MCMS fields correspond directly with the fields expected by the Ubuntu application, so there does not appear to be significant data transformation required. Existing Ubuntu Processing Logic The existing PHP application selects recent SOHEAD records using logic equivalent to: SELECT sonum, entdt FROM non

Skills

MySQL SQL Python PHP Linux

Notification History

Channel	Type	Status	Sent	Error
No notifications.

User Actions

Action	Acted at
No actions.