BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
balraj
Quartz | Level 8

Hi community,

 

Is there any possibility of connecting SAS with Cassandra? If Yes, Please guide me with the steps/links to connect to  it

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
JuanS_OCS
Amethyst | Level 16

Hello @balraj,

 

I don't know if there is a SAS/ACCESS module specific to Cassandra ( you can confirm by opening a track with SAS Technical Support), but I can confirm it is possible to connect with a SAS/ACCESS to ODBC license and an ODBC driver for Cassandra ( https://www.google.nl/search?q=cassandra&oq=cassandra&aqs=chrome..69i57j69i60.1511j0j7&sourceid=chro... )

 

While this option would not allow you to have in-database processing, I also understand you probably won't need this feature, since you are posting this question on the Visual Analytics community, therefore no real ETLs.


Does it help your question?

 

Kind regards,

Juan

View solution in original post

4 REPLIES 4
JuanS_OCS
Amethyst | Level 16

Hello @balraj,

 

I don't know if there is a SAS/ACCESS module specific to Cassandra ( you can confirm by opening a track with SAS Technical Support), but I can confirm it is possible to connect with a SAS/ACCESS to ODBC license and an ODBC driver for Cassandra ( https://www.google.nl/search?q=cassandra&oq=cassandra&aqs=chrome..69i57j69i60.1511j0j7&sourceid=chro... )

 

While this option would not allow you to have in-database processing, I also understand you probably won't need this feature, since you are posting this question on the Visual Analytics community, therefore no real ETLs.


Does it help your question?

 

Kind regards,

Juan

balraj
Quartz | Level 8

@JuanS_OCS you've answered my question.

 

Thank you for your time 🙂

JuanS_OCS
Amethyst | Level 16

Many thanks @nicolewells, Nicole. Very useful, your update!

nishanth
Calcite | Level 5

Yes, absolutely. You can use an ODBC driver. Here is a tutorial describing an easy way to access data into SaS/Access: SAS Access Tutorial . Please note that this tutorial uses the MongoDB ODBC driver, but the same steps can be followed with Cassandra ODBC driver. Let me know if you have any other questions as you try this tutorial. I work with DataDirect and I will be happy to get you in touch with a product expert.

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!

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
  • 4 replies
  • 3338 views
  • 3 likes
  • 3 in conversation