DSXchange

Please introduce logic to allow for inline command statements to be ran from within the ini file when it is being passed to the job. This allows for dynamically adding date logic to files and many other valuable things.

Please don't abort jobs when parameters are passed that don't exist within the job. Please just ignore them. Do post an informational message to the job log, but do not post this as a warning or critical error. I know that it is very easy for many to create their own solutions to ignore the paramete...

So, I believe that in order to do effective ETL/DGP/EDM that the following must be accomplished. For most, I don't think this can be accomplished by status quo or by simply buying a so called silver bullet product. While software is important, these things must be accomplished by a dedicated group o...

ETL is more than tools or an attempt at organized chaos. Good ETL is designed to remove chaos completely for organized structure. And, while good ETL does require good tools like Datastage, but more than tools, it is a companies dedication to a data governance policy and to an enterprise data manage...

eostic wrote:DS should obey the OS security rules. Having another layer in a tool like DS opens doors to other problems.

Yes, it should definately obey the OS security rule. In addition, I'd like it to obey these rules due to how Universe requires file permissions on the projects.

Thanks.

ray.wurlod wrote:And if it's not owned by that user?...

Sorry. Abort.

Thanks.

I would like to be able to define an owner check for the APT_CONFIG_FILE that cannot be overwritten by a user.

If defined, say APT_CONFIG_OWNER=dsadm

Then, the APT_CONFIG_FILE must be owned by said owner.

Thanks.

I should be able to define a set of storage locations on disk. DataStage should check these settings in Globals and/or if locally defined to make sure that the users are writing to these said locations and/or to locations below the specified locations. If I say, STORAGE_LOCATION_1=/Proj01 STORAGE_LO...

ray.wurlod wrote:This one might get messy in a grid environment!

This option just says where the tool will start its navigation from. Not an actual default store here, but for the tool to navigate from when selecting files or locating files from CLI.

Thanks.

I should be able to define a set of no storage locations on disk. DataStage should check these setting in Globals and locally if defined to make sure that NO USER can write to these locations. These location might include installation locations, etc... If I say, NO_STORAGE_LOCATION_1=/dstage Then, n...

The default storage location on disk should be able to set as an environment variable within Globals and also locally. This path indicates the location the starting location when choosing any option to store or locate a file on disk. Basically, when you go to save a file in a stage it should start f...

All jobs should be able to have a set of default parameters if so chosen. For instance, JobName, ProName, FilePath should be able to defined in Globals as default parameters for all jobs and when any job is created that job should have those variables included within the job. However, should the val...

The stage settings should be able to modified and stored in the Globals project. These settings are related to transaction counts, username variables, password variables, NLS settings, delimeters, etc... Anything that can be specified or set in a stage should be able to be changed in Globals project...

Should the centrally managed Globals metadata capabilities be introduced... I would like capability of specifying that no project can define metadata except for within the Globals project and this can only be done by a user designated with the Metadata management role from within the registry. Thus,...

Should the Globals project capabilities be implemented... Allow for the moving of the storage of all project metadata to be consolidated into the Globals project. This will happen automatically (behind the scenes) and the end user using a local project will be exposed to all Metadata defined and sto...