This shows up as a info line in the log, to me.  Possibly a difference in our versions of SAS (I am using 9.4m6).   https://github.com/FriedEgg/SAS-JDBC-Spring-Boot-Example ... View more

It is definitely possible, but it's important to note that the JDBC driver isn't exactly... complete... (by which, I mean, a number of features that other databases more commonly used in this context are missing, such as the various timeouts)   The biggest issue you're going to have with something like mybatis is that automapping uses the method ResultSetMetadata.getColumnLabel, which, in SAS returns the column label, naturally.  But in general it returns the column name alias.  This difference in behavior causes mybatis to fail and this can be corrected by setting the configuration property use-column-label=false.   mybatis.configuration.use-column-label=false   ... View more

Make sure you have all the correct libraries in your classpath:   log4j.jar sas.core.jar sas.security.sspi.jar sas.svc.connection.jar   In your application.properties   spring.datasource.url=jdbc:sasiom://workspace.server.hostname.com:8591 spring.datasource.username=myusername spring.datasource.password=mypassword spring.datasource.driver-class-name=com.sas.rio.MVADriver DemoApplication.java   package com.github.friedegg.demo; import org.springframework.boot.CommandLineRunner; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.ApplicationContext; import org.springframework.context.annotation.Bean; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import javax.sql.DataSource; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; @SpringBootApplication public class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } @Bean public CommandLineRunner commandLineRunner(ApplicationContext ctx) { return args -> { DataSource ds = (DataSource)ctx.getBean("dataSource"); JdbcTemplate jdbcTemplate = new JdbcTemplate(ds); String SQL = "select * from sashelp.class"; List<Student> students = jdbcTemplate.query(SQL, new SashelpClassMapper()); for (Student student : students) { System.out.printf("%s is %d years old.%n", student.name, student.age); } }; } class Student { private String name; private Integer age; public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } public String getName() { return name; } public void setName(String name) { this.name = name; } } class SashelpClassMapper implements RowMapper<Student> { public Student mapRow(ResultSet rs, int rn) throws SQLException { Student student = new Student(); student.setName(rs.getString("name")); student.setAge(rs.getInt("age")); return student; } } } Console Output:   Alfred is 14 years old. Alice is 13 years old. Barbara is 13 years old. Carol is 14 years old. Henry is 14 years old. James is 12 years old. Jane is 12 years old. Janet is 15 years old. Jeffrey is 13 years old. John is 12 years old. Joyce is 11 years old. Judy is 14 years old. Louise is 12 years old. Mary is 15 years old. Philip is 16 years old. Robert is 12 years old. Ronald is 15 years old. Thomas is 11 years old. William is 15 years old. ... View more

pywin32 is a very finicky library.  Make sure you have the correct version installed for your version of Python and bittedness.   Use this link to get a good version of pywin32 and see if that resolves your issue.   https://github.com/mhammond/pywin32/releases ... View more

As @Kurt_Bremser says, you aren't using the correct URL, so the response you are getting should just be HTML and not the file you actually want.   It is not a simple operation to do what you want and I'd recommend that you use one of the many command line tools available for downloading files from Google Drive instead of attempting an implementation yourself using PROC HTTP (though certainly not impossible).   https://github.com/gdrive-org/gdrive ... View more

@Quentin, that request is simple enough...   filename foo url "https://www.sas.com/content/sascom/en_us/events/sas-global-forum/program/proceedings/jcr:content/par/styledcontainer_1306083555/par/tabwrapper/tabwrapperpar/tab/tabpar/styledcontainer/par/listgrouppdf.ajaxlist.html"; %macro getPaper(url); %local big small; %let big=%scan(&url,-1,/); %let small=%scan(&big,1,-); filename _&small "%sysfunc(pathname(work,l))\&big"; proc http url="&url" method='get' out=_&small; run; ods package(pckg) add file=_&small; %mend; *filename pckg "%sysfunc(pathname(work,l))\sgf2018.zip"; ods package(pckg) open nopf; data _null_; length pdf $1024.; infile foo dsd dlm=' '; input @'<a href=' pdf :; if substr(pdf,max(lengthn(pdf)-2,1))='pdf'; call execute('%nrstr(' || '%getPaper(' || trim(pdf) || ')' || ')'); run; ods package(pckg) publish archive properties( archive_name='sgf2018.zip' archive_path="%sysfunc(pathname(work,l))" ); ods package(pckg) close; filename _all_ clear;   In case anyone was wondering... by uncompressed file size, the biggest paper is: E-Poster 2876 Predictive Modeling of the Journey from H-1B to Permanent US Work Visa by Shibbir Khan, Clark University, Graduate School of Management, Worcester, MA, USA   and the smaller is: Breakout 1778 A Macro for Ensuring Data Integrity When Converting SAS® Data Sets by Richard D. Langston, SAS Institute Inc.   and the highest compression ratio E-Poster 1664 Weather Data Cleansing for Electrical Load Forecasting by Aubrey Condor, University of Central Florida   and the largest compressed file size Breakout 2910 Getting Started with Survival Analysis Course Notes by Marc Huber, SAS Institute, Inc.   The resulting zip file is is about 311Mb and contains 427 pdfs ... View more

Making a small adaption to the code I posted in a similar thread last year   Furthest Great Circle Distance to Denver, CO   City Country Distance (km) Curepipe Mauritius 17272.8 Location data from mapsgfk.world_cities   The furthest more populous area would, similar to Orlando, FL would be on the Western shore of Australia.   Personally, my travel distance is about 2,580km but had this been a few years ago, when I lived in Denver, it would've been easily walkable. ... View more

https://github.com/WizardMac/ReadStat   SAS7BDAT is a proprietary data format specific to the SAS platform, so your best option is use some other means.  Either a SAS licensed provider or converting to an open data format that your VC++ program can natively access. ... View more

Just finished up a new install and I did notice the "Zulu Platform..." and thought that was new!  Thanks for validating. ... View more

ODBC or OLE DB or ADO through IOM... There are many options that come down to preference and specific use case. All these options require SAS access, local or remote. There are open source libraries available that do not require SAS as well as other third-party commercial tools as well. ... View more