DSXchange

Firstly, I had to laugh at the idea of IBM giving you the source code. There's no way they're going to give you their secret sauce. Just saying. On the question at hand though, it's been a while since I dug full-on into this stuff, so here goes not much... The match frequency files can skew the scor...

Out of curiosity, what is the maximum length of the actual data in your field?

Yeah, that argument is a slippery slope to nowhere good. The business don't care about proper IT dev practices, that's not their job. Expect them to push for the most expedient thing they can get away with. It's up to IT leadership to define and defend the integrity of their environment and practice...

MettleCI offers what it calls Compliance checking as part of its CICD processes, and it can also be run standalone through the Workbench. It has a number of pre-canned rules to check things like naming standards, use of deprecated stages, adherence to best practices (no hardcoded DB credentials or f...

MettleCI offers what it calls Compliance checking as part of its CICD processes, and it can also be run standalone through the Workbench. It has a number of pre-canned rules to check things like naming standards, use of deprecated stages, adherence to best practices (no hardcoded DB credentials or f...

Hi Paul,

I checked those links, and the 1st and 3rd have a link to the pdf at the bottom of the page.
The 2nd was a pdf.

Or are you saying the old pdf's were different and you want those ones?

Sampling can be a tricky one. I have seen large tables profiled in the past and set a pre-defined sample size, eg: 1M records. Need to be careful here. In one example, review showed a particular field was not populated. Failed the sniff test, so I took a look. Turns out the table had 495M records an...

Dumb question I'm sure, but you selected "Enable drill down security" in the Details tab of the Project Properties?

Drill Down Role is project-specific and IIRC the role is ignored (ie granted by default) if you don't have that property set.

Might be worth checking this out:

https://www.mettleci.com/

Had to go with the views, unfortunately.
HANA is not on Information Server's list of ODBC supported databases.

Hi Craig, Yeah, we've resigned ourselves to that fact too. We were hoping to avoid that, as: - we don't own the database so only have read-only access to it. - the issue affects around 14k of the 50k tables in the database. 8-( I'd better get started then! ;-) PS: The thing that annoys me is that if...

Hey Ray, I raised a PMR but they just came back with "SAP HANA is not supported". This isn't just a HANA problem. I've seen this sort of thing in SQL Server in the past, and SQL Server is obviously supported. The silly thing is that the code that generates the SQL recognises that there is ...

I am attempting to run column analysis on SAP HANA. We have: - connected to it via ODBC through the HANA driver - and have successfully imported and shared metadata through IMAM - created an IA project and associated the data When it comes to the column analysis, some of the tables were successfully...

Hi guys, Yes, I've tested the regex and it works. I think this one is on me. Someone had made a change to the settings to reuse the IADB tables, and the generate FD tables is mutually exclusive to that. I switched it over and re-ran CA and I had them. Still interesting that the standard DataClasses ...