BookmarkSubscribeRSS Feed
chirumalla
Calcite | Level 5

Hi,

In DI studio development. I have data in DI server I want to append this data into EBI server datasets and I need to use trigger file in DI server for LSF jobs.  both are different servers and in different environment(Not using Spds). advise me how to connect both servers. if any sample code pls share with me.

2 REPLIES 2
jakarman
Barite | Level 11

please descibe the situation better.

DI studio is a tool connecting to a Workspace Server (WS) as part of a EBI installation

When you develop code it is a DTAP (Develop / Test / User Acceptrance / Production) approach. Naming and logical machines will be different between those.  When you are running in P there will be a LSF but LSF in a Grid can manage many Servers.

To get code independent of DTAP should be a major design in this. By that you can fullfill the change process requirements.

It Could be using system environment variables or macro-vars are needed for that.

Who is helping you with that?   

---->-- ja karman --<-----
LinusH
Tourmaline | Level 20

Assuming that the append to BI is the question here (not LSF?).

Two ways (of many more surely):

  • If you have SAS/CONNECT licensed, you could connect to the other server, upload your changes, and load the table on the remote host.
  • Your data is stored/accessible via shares (UNC), then just register the BI table as local to the DI Server, and then proceed as normal.
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 426 views
  • 0 likes
  • 3 in conversation