BookmarkSubscribeRSS Feed
jitinsethi07
Obsidian | Level 7

I ran:

proc setinit noalias;
run;

and found that following products are available:

---Base SAS Software 30DEC2018
---SAS/GRAPH 30DEC2018
---SAS Integration Technologies 30DEC2018
---SAS/Secure 168-bit 30DEC2018
---SAS/ACCESS Interface to PC Files 30DEC2018
---SAS/ACCESS Interface to ODBC 30DEC2018
---SAS Workspace Server for Local Access 30DEC2018
---High Performance Suite 30DEC2018
---SAS Search and Indexing Server 30DEC2018
---SAS Web Crawler Server 30DEC2018
---SAS LASR Analytic Server 30DEC2018
---SAS Visual Analytics Hub 30DEC2018
---SAS Visual Analytics Services 30DEC2018
---SAS Visual Analytics Base 29DEC2018
---Advanced Programming for LASR Analytic Server 30DEC2018
---SAS Visual Analytics Server Components 30DEC2018
---Visual Analytics Explorer 30DEC2018
 

 

Should I be able to connect to MYSQL db by just using LIBNAME or SQL PASSTHROUGH?

Kindly Help!

Thanks!

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hello @jitinsethi07,

 

according to this license, you have ODBC, but not MySQL, hence no in-database processing.

 

You can connect with libname and pass queries with passthrough (with a few contraints), though.

 

Please read: http://documentation.sas.com/?docsetId=acreldb&docsetTarget=p1f29m86u65hken1deqcybowtgma.htm&docsetV...

 

Please mind this: I would highly recommend to first prepare your data well, filtered and sorted, into SAS tables, that can be easily and quickly loaded into LASR (RAM memory), to not lose the great performance that SAS Visual Analytics can provide you.

 

If you do otherwise, every time you query and join tables from external data sources (such as MySQL), SAS will try to first download the full table/s into WORK tables and then do the join/query, hence, losing performance and efficiency.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

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