cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
VincentRejany
Friday
  • 118 Posts
  • 18 Likes Given
  • 16 Solutions
  • 48 Likes Received

Re: DM Server Issue in Data Management Studio

by Fluorite | Level 6 in SAS Data Management
‎10-20-2022 01:55 AM
‎10-20-2022 01:55 AM
Resolution Do following: 1. Bring up the DM Server if it is not running. 2. Check and correct the datamodel.properties entry if needed. Greeting, Rachel Gomez ... View more

Re: getting error -404: DQ Engine File read errors. File was not found...

by Fluorite | Level 6 in SAS Data Management
‎10-20-2022 01:47 AM
‎10-20-2022 01:47 AM
Tips to fix- Check the Submitted URL. Clear Browser Cache. Clear Browser Cookies. File Upload Exceeds Server Limit. Clear DNS Cache. Deactivate Browser Extensions. Regards, Rachel Gomez ... View more

Re: Performance tuning: DM Server and Oracle

by SAS Employee in SAS Data Management
‎09-08-2022 05:02 PM
‎09-08-2022 05:02 PM
Agree with SASKiwi. If the Union can be done in Oracle that would be better. Next you can fine tune the parameters I mentioned in another post in the cluster node. ... View more

Re: Dataflux business rules

by SAS Employee in SAS Data Management
‎09-08-2022 05:00 PM
‎09-08-2022 05:00 PM
Hi Looks Weird. Please open a ticket by SAS Tech Support ... View more

Re: Data Flux data management server migration from statging to produc...

by Fluorite | Level 6 in SAS Data Management
‎08-02-2022 07:01 AM
‎08-02-2022 07:01 AM
Thanks for the help ... View more

Re: Data Flux data Mangement Studio 2.9

by SAS Employee in SAS Data Management
‎07-11-2022 10:14 AM
1 Like
‎07-11-2022 10:14 AM
1 Like
Hi   If you want to run a SAS DataFlux data/process job on SAS DataFlux DM Server, connection names have to be the same between the studio and the server. As far as I know, ODBC connections in DataFlux are schemaless, and you should see the all the schemas your db user has access to. Don't forget to save your credentials by right clicking on the connection and "save". The credentials should be also copied on the server. https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.8/dmpdmsug/Content/dfU_T_DataConnOver.html ... View more

Re: SAS DATAFLUX Variable into a process job

by SAS Employee in SAS Data Management
‎07-07-2022 05:06 PM
‎07-07-2022 05:06 PM
Mind that variables are passed as TEXT ... View more

22Q1 ODBC drivers update for DataFlux Data Management Studio & DataFlu...

by SAS Employee in SAS Data Management
‎04-21-2022 06:25 AM
‎04-21-2022 06:25 AM
Dear Community   From now on, SAS ®  is providing and supporting quarterly updates to the embedded Open Database Connectivity (ODBC) drivers for DataFlux Data Management Studio and DataFlux Data Management Server 2.8 and 2.9.  A new update is available for DataFlux Data Management Server , version 2.9 : Hot Fix: J6K010 - Released: March 23, 2022 , Download link for J6K010 A new update is available for DataFlux Data Management Server , version 2.8 : Hot Fix: H3W006 - Released: March 23, 2022 , Download link for H3W006 A new update is available for DataFlux Data Management Studio , version 2.9 : Hot Fix: J6J007 - Released: March 23, 2022 , Download link for J6J007 A new update is available for DataFlux Data Management Studio , version 2.8 : Hot Fix: H9M005 - Released: March 23, 2022 , Download link for H9M005 With this hot fix, SAS removes support for Apache Spark SQL connectivity through ODBC within SAS Data Management Platform 2.8 and 2.9. Future releases of SAS Data Management, including DataFlux Data Management Studio and DataFlux Data Management Server, will no longer deliver support for Apache Spark SQL connectivity through ODBC. If this driver was used, you can migrate to ODBC or Java Database Connectivity (JDBC) drivers that are available for free from Spark engine vendors.   Please refer to the installation note 66084 ... View more

Re: Register a Denodo View with field restrictions

by SAS Employee in SAS Data Management
‎04-21-2022 05:50 AM
‎04-21-2022 05:50 AM
Unfortunately we don't officially support Denodo. Would suggest your register views with fields you can access. ... View more

Re: SAS® Studio Flows and Steps Q&A, Slides, and On-Demand Recording

by SAS Employee in Ask the Expert
‎03-14-2022 06:18 PM
‎03-14-2022 06:18 PM
SAS Studio Flows have been released in November 2020 with the first release of Viya 4. https://youtu.be/tfjrhI6bMSw ... View more

Re: How to anonymize the Data (not masking)

by SAS Employee in SAS Data Management
‎12-15-2021 11:42 AM
‎12-15-2021 11:42 AM
We support Data Hashing as part of  SAS code (MD5, SHA1, 256, 384, 512, CRC32 https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n0b8k12x6fdw4ln1snlsqrxd53gy.htm and SAS Federation Server https://go.documentation.sas.com/doc/en/fedsrvmgrcdc/4.4/fedsrvmgrug/n1s7wae3mndbnmn1145y1lezasd8a.htm   You can also refer to this document focusing on the GDPR use case https://communities.sas.com/t5/SAS-Communities-Library/SAS-Federation-Server-for-GDPR-Data-Masking/ta-p/466772   Lastly, within the SAS QKB CI 32 we have been introducing specific definition for data masking:     ... View more

Re: Import metadata from qlikview to SAS

by Pyrite | Level 9 in SAS Data Management
‎11-09-2021 08:03 AM
2 Likes
‎11-09-2021 08:03 AM
2 Likes
Hi Team,   Got to know we can export XML from Qlikview and then that should import using SAS MetaData Loader. Working on that will post here the solution. ... View more

Re: Address Validation Using SAS

by SAS Employee in SAS Data Management
‎10-26-2021 06:12 PM
2 Likes
‎10-26-2021 06:12 PM
2 Likes
On SAS Viya 4, we will be introducing integration with Loqate data enrichment APIs including address verification over 240 countries, phone verification and email verification. These capabilities will be soon made available within SAS Studio ... View more

21Q3 ODBC drivers update for DataFlux Data Management Studio & DataFlu...

by SAS Employee in SAS Data Management
‎10-26-2021 06:07 PM
‎10-26-2021 06:07 PM
Dear Community   From now on, SAS ®  is providing and supporting quarterly updates to the embedded Open Database Connectivity (ODBC) drivers for DataFlux Data Management Studio and DataFlux Data Management Server 2.8 and 2.9.  A new update is available for DataFlux Data Management Server , version 2.9 : Hot Fix: J6K004 - Published 05OCT2021 , Download link for J6K004 A new update is available for DataFlux Data Management Server , version 2.8 : Hot Fix: H3W004 - Published 05OCT2021 , Download link for H3W004 A new update is available for DataFlux Data Management Studio , version 2.9 : Hot Fix: J6J003 - Published 05OCT2021 , Download link for J6J003 A new update is available for DataFlux Data Management Studio , version 2.8 : Hot Fix: H9M003 - Published 05OCT2021 , Download link for H9M003 With this hot fix, SAS removes support for Apache Spark SQL connectivity through ODBC within SAS Data Management Platform 2.8 and 2.9. Future releases of SAS Data Management, including DataFlux Data Management Studio and DataFlux Data Management Server, will no longer deliver support for Apache Spark SQL connectivity through ODBC. If this driver was used, you can migrate to ODBC or Java Database Connectivity (JDBC) drivers that are available for free from Spark engine vendors.   Please refer to the installation note 66084 ... View more
Contact Me
Online Status
Offline
Date Last Visited
Friday
Group Hubs for VincentRejany
View All
Likes given to
View All
Quick links