Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Unidata and MySQL two-way communication

A client is using a software system that has a Unidata database. This system setup migrates most (maybe all) of the information to a MySQL database on a different server for reporting use. We are looking to build an application that changes or adds new data to the MySQL database and would like that information to be migrated back to the Unidata database.

From what we've learned we need to map the MySQL fields to certain Unidata fields. However, we cannot find much documentation or information about how to make this process work. Any information will be much appreciated.
0
Roderick Wolsifer
Asked:
Roderick Wolsifer
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
A little searching learned me that you can indeed develop web services on a Unidata server, see https://u2devzone.rocketsoftware.com/ignite/development-tools.html, using a package called DBTools.

More info: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools

Don't ask me for details, for I don't have a clue about Unidata... I'm just playing the piano here...
0
 
Roderick WolsiferAuthor Commented:
We've read those documents. The server that hosts the software and Unidata is a production server of vital importance to the business, so we aren't free to change things in a trial and error method. We have tried connecting via the DBTools Extensible Administration tool. We can connect via the demo account but cannot find the needed account name and user/pass combination to show the database in that we need to see. We are looking to find a way to connect so that the information going from Unidata to MySQL can be sent back from MySQL to Unidata. We appreciate the attempt, though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now