JDBC access to Enscribe and SQL/MP from other platforms?

[Keith Dick]

I am looking for a way to access Enscribe and SQL/MP data from a program running on a non-NonStop system, preferable via JDBC, but willing to look at other possibilities.

I am aware of Attunity Connect, and Cornerstone DynaAccess (which apparently is not actively marketed).

Are there any others that I ought to be evaluating?

[Dave]

I'm not sure if they support JDBC, but another product for cross-platform access from/to any number of systems via a variety of protocols is Netweave Distributed Services. I used it for a couple of large-scale projects many years ago after the original product was completely rewritten. You can see them netweave.com and check the status of the product.

[comforte...@gmail.com]

Regarding SQL/MP I think you should be also good to go "as is" on most platforms as there are JDBC drivers available from HP for SQL/MP. So no product needed!

For Enscribe: If you are willing to write a Pathway server to do the actual database work, the comForte CSL product will expose this Pathway server in a rather flexible way: as SOAP server, as JSON/REST server, towards native APIs in multiple languages on the client. CSL focuses on providing access to *Pathway* rather than to a database; in many instances it is better to do the actual DB work on the NonStop (JDBC used to be notoriously slow for complex queries).

If you want to use JDBC, the comForte EscortSQL product will convert the database from Enscribe to SQL/MP - without requiring any application changes.

Your best choice will depend on the complexity of your "queries" against both databases, and, of course, budget.

[Randall]

You can use the SQL/MX JDBC Type 4 driver to access SQL/MP tables, providing you create aliases in an SQL/MX catalog. Enscribe, not so much.

[nitinma...@gmail.com]

JDBC to SQLMP/MX can be done using the SQLMX type 4 driver.

But to establish JDBC connection to an Enscribe file, there is no direct method.

Apart from the paid tools that you mentioned that provide JDBC to Enscribe files there are other ways too:
1) Convert the Enscribe files to SQLMP/MX tables and then use the type 4 driver for JDBC.
2) Send a request from the other platform via TCP/IP to a JAVA pathway server (Server Process Type OSS). Then using the TDMEXT.jar inside the java pathway server to perform DML on Enscribe files. Note the TDMEXT.jar has classes that support Enscribe read/write.
3)A SOAP webservice can be established using ACI's WEBGATE product, that runs on tandem. The request from the SOAP can be sent to the pathway server that would access Enscribe files.

[Marius]

AtomBox, a free JavaScript interpreter for the Guardian, Unix or Windows has a means of mapping DDL's to its an internal data model. If you want just reading access, I can send you how you can read Enscribe files (key sequence, entry sequence, etc) on Unix or Windows. You can find out more on www.inductum.com/atombox, download it and take it for a spin.

[george.z...@gmail.com]

Hello,

I need to read some Enscribe files and their associated DDL files on a HP tandem
Can you give me some ideas? I need to do an external program in Java or C# to read the tandem’s Enscribe files (mapping to DDL as well).
Can you please send me the TDMEXT.jar from JToolKit?
Please attach the TDMEXT.jar to an email to me.

Many thanks,
Geo

[george.z...@gmail.com]

On Wednesday, October 14, 2015 at 12:30:47 AM UTC+2, Keith wrote:

[Keith Dick]

For accessing SQL/MP tables via JDBC, the way HPE recommends is to set up SQL/MX aliases for the SQL/MP tables, and use the type 4 JDBC driver for SQL/MX.

The JDBC driver HPE has for SQL/MP is type 2, which means it can only run on a NonStop system, plus HPE says it has a number of problems, and is best avoided. The JDBC driver for SQL/MX, being type 4, can be used on any host, and it works well.

As far as I know, HPE does not offer JDBC access to Enscribe files. I don't know about the Attunity or Cornerstone products you mention, and I don't know of any other non-HPE products for JDBC access to files or tables on a NonStop system. There might be others, but I am not aware of any.

For one-time needs, if the Enscribe data was designed well, there is a fairly easy way to load an Enscribe file into a SQL/MP table. Then you could use JDBC to access the data from the copy in the SQL/MP table. You probably would not want to use that approach for an ongoing data flow.