About cgwaters

cgwaters

I need to know the number of times each view in my HANA system has been executed over the last few months. I also need to know which users have executed those views. Is that possible? Does auditing need to be set up to obtain those metrics? If so, ca...

cgwaters

In my batch job script, I'd like to implement the logging of metadata to a text file on my DS server. The metadata would include date, time, name, substitution parameter values, datastore field values, etc. Obviously, some of this metadata is already...

cgwaters

For more detailed job logging, I would like to include the runtime values of my datastore configurations and substitution parameters. Is that metadata exposed and available for including in job logs?

cgwaters

I'm trying to use SAP Data Services to write data to an AWS Redshift database. I installed the Redshift ODBC driver on my DS server and then used the Windows ODBC Data Source Administrator to create a System DSN. In Data Services Designer I created...

cgwaters

I'm trying to write HANA SQL to obtain the Ship To partner (from ECC.VBPA) for every billing document line item (ECC.VBRP). Tables VBRP and VBPA are joined on fields VBELN (billing document number) and POSNR (billing document line item). Ship To part...

cgwaters

How can the integrity of a repository be checked?

cgwaters

Thanks! I saw both of those methods prior to my original post.Setting up a flat file and a dataflow seemed cumbersome; I also wasn't sure what to use as the source of the query transform.I was hoping for an equivalent of the print() function but that...

cgwaters

Good to know that substitution parameters *can* be referenced in scripts. But when I run a simple batch job that contains nothing more than a script that references a substitution parameter...print('[$$UserDir]');...where $$UserDir is set to "\\Serve...

cgwaters

Good to know that substitution parameters *can* be referenced in scripts.

cgwaters

Is the VS Code extension compatible with Microsoft Windows? The Prerequisites section states:"The Cloud Foundry CLI is required for accessing the list of databases from SAP HANA Database Explorer."The link in that sentence leads to https://docs.cloud...

User Statistics

User Activity

Determine number of times each HANA view has been executed, and by whom?

Write to a text file from within script?

Include in job log the values of datastore configuration and substitution parameters

Syntax for specifying bulk loader option S3 file location?

HANA SQL to obtain Ship To for billing document line items?

Re: Data Services repositories status

Re: Write to a text file from within script?

Re: Include in job log the values of datastore configurat...

Re: Include in job log the values of datastore configurat...

Re: SAP HANA Database Explorer VSCode Extension Getting Started Tips