Solved

Unidata and MySQL two-way communication

Posted on 2015-02-03
2
232 Views
Last Modified: 2015-03-23
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
Comment
Question by:Roderick Wolsifer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 40588128
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
 
LVL 1

Author Comment

by:Roderick Wolsifer
ID: 40589828
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question