BookmarkSubscribeRSS Feed
rohanro
Calcite | Level 5

hello i have a data with tables in SAS enterprise guide. I am a java developer. I want to use the data in the SAS EG. But I cant find connection to SAS EG through java so as to use the tables in SAS EG. So i have decided to transfer the entire data with tables in SAS EG to oracle DB

How can i transfer those tables to oracle database or mysql database.

can you help me with the detailed steps to follow so that the entire tables in SAS EG should be transfered to Oracle or MySQL DB

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Who owns or admins your SAS environment?  You should speak to them about this or alternatives.  You could for instance have the data dumped out to flat csv file for instance, which would negate the need for third party software.  Or you could read XPT using the open source file format.  Various options, but needs someone who knows your system and what you have available.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 870 views
  • 0 likes
  • 2 in conversation