Insert variables into SAS using JAVA (IOM Bridge). Should i use CORBA stubs and JDBC or is there any other alternative?

Question

This is part of my code snippet WorkspaceConnector connector = null; WorkspaceFactory workspaceFactory = null; String variableListString = null; Properties sasServerProperties = new Properties(); sasServerProperties.put("host", host); sasServerProperties.put("port", port); sasServerProperties.put("userName", userName); sasServerProperties.put("password", password); Properties[] sasServerPropertiesList = { sasServerProperties }; workspaceFactory = new WorkspaceFactory(sasServerPropertiesList, null, logWriter); connector = workspaceFactory.getWorkspaceConnector(0L); IWorkspace sasWorkspace = connector.getWorkspace(); ILanguageService sasLanguage = sasWorkspace.LanguageService(); //send variable list string //continued I need to send the "variableListString" to the SAS server through IOM bridge. Java SAS API doesn't give explicit ways to do it. Using CORBA and JDBC is the best way to do it?? Give me a hint how to do it. Is there any alternative method to do it??

Answer 1

The IOM Bridge for Java provides a way to interact with a SAS session from a Java application. While you've correctly set up the connection to the SAS server using the Workspace API, the next step involves passing data (like your variableListString) to the SAS environment.

Using CORBA (Common Object Request Broker Architecture) stubs and JDBC (Java Database Connectivity) can be a solution, but it's typically more complex and might not be necessary for your use case. CORBA and JDBC are more suited for situations where you need to integrate with other systems or databases, not just to send data to a SAS server.

A simpler alternative might be to use the SAS IOM Data Provider, which is specifically designed for data transfer between Java and SAS. Here’s a basic approach to consider:

Use the SAS Stored Processes: You can create a stored process in SAS that accepts parameters. Your Java application can then call this stored process using the IOM Bridge and pass variableListString as a parameter.

Direct Data Transfer: If variableListString represents a dataset you want to transfer, consider using the IOM data provider to directly transfer data from Java to SAS. This method is more straightforward than dealing with CORBA or JDBC.

SAS Scripting: Another approach is to dynamically generate SAS code in your Java application that incorporates your variableListString and then execute this code using the ILanguageService interface.

Here's a basic outline of how you might modify your existing code to send variableListString: // Assuming variableListString is a string that you want to send to SAS

String mySasCode = "data _null_;\n" +

"myString = '" + variableListString + "';\n" +

"/* More SAS code to process the string */\n" +

"run;";

// Execute the SAS code

sasLanguage.Submit(mySasCode);

This is a simplistic example, but it illustrates the principle. You'd replace the commented section with whatever SAS code is needed to process variableListString.

In conclusion, while CORBA and JDBC are options, they might be more complex than necessary for your requirements. Directly interacting with SAS using the IOM Bridge and SAS Stored Processes or dynamically generating SAS code in Java can be more straightforward and efficient for your task.