Highlighted
New Member.
722 views

Relativity and Unix

Is anyone using Relativity in a unix environment where you are sharing Cobol data with Windows?  I am trying to push data from Unix to SQL using a linked server and also update Cobol data from MSSQL Server Agent and from scheduled tasks running visual studio projects. Any suggestions appreciated as we are trying to determine if we have the right product or not. Eventually I also plan to use Visual Cobol with Esql to get Windows SQL data to be available to Cobol in unix.

0 Likes
1 Reply
Highlighted
Knowledge Partner
Knowledge Partner

RE: Relativity and Unix

CliffS,

There are, I am certain, hundreds of installations of Relativity doing just that: providing ODBC SQL access (on Windows) to data that resides on Unix.

I am not sure that push data is possible.  MS SQL Server can link to ODBC tables in a mode that allows the user of SQL Server to have access to the data from the Unix server.  So, the user is getting the live data as it exists on Unix at the moment of access.  I would consider that more a pull operation.  (My interpretation of push data would be, "Under the control of the linked server, move data from the linked server into SQL Server native tables.")

However, given the rest of your description for your current application, yes, Relativity seems to be the correct choice.


Tom Morrison
Consultant

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.