Can command line take input parameters

More
12 years 1 week ago - 12 years 1 week ago #3897 by Allen
Hi,

I understand that the using command line aetlcl <package id> can execute a package, and inside the pacakge you can define variables. But can we pass parameters using command line? Is it possible to add this functionality if currently there isn't any?

I'll explain why I need this. Our clients require STP files from us, and different client asks for different formats. Therefore we need to design different transformations according to their request and there are a lot of transformations we created. And this may keep growing and changing if clients request.The STP files data is from several tables in our database. We want to store all the transformation names in a new table and link this to our clients. So when we generate file we know which tranformation to use for the target client. We use command line because we can use it in our own system to call it whenever we need to. We want to pass the client id and related data to the transformation reader. So can we call the transformation from command line and add some input parameter as well?
Last edit: 12 years 1 week ago by Allen.

Please Log in or Create an account to join the conversation.

More
12 years 1 week ago #3900 by admin
Sounds like a good idea.

We will add it to the next release

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 1 week ago #3908 by Allen
Thanks Mike,

We are in the middle of designing the new STP solution and this functionality is very important to us. I really appretiate that you can help with this.

Please Log in or Create an account to join the conversation.

More
12 years 1 week ago #3912 by admin
Can you tell us more about what you are trying to achieve maybe there is a better solutions..

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 1 week ago #3920 by Allen
Ok.

We will have a table that have Id (may be a client Id, company Id, etc), a field called "type" which is to indentify the Id type, the transformation name (The transformation defines the format that the client or company request) and the file name. We will have another table that contains data to prepare for the STP file. This talbe is dynamic which means after STP file generated, the data will be cleared from the table. We have a stroed procedure to populate the table depending on which client or company request STP files. Our system will call the stored procedure and then run ETL command line to generate STP files. So for each transformation the reader will have a select statement to pick up a client's records from the table given the client's Id and type. What we want is a command line that can call a transformation and pass the Id and type data.

So in general, I would appreciate that if you can add a command line function that take 3 or more parameters (1st will be the transformation name and transformation can pick up the rest as variables). It's like passing variables from command line.

Please Log in or Create an account to join the conversation.

More
12 years 5 days ago #3928 by admin
It was implemented in latest version

4.2.6.19

Support for MySQL 5.5 was introduced
Boolean fix for MySql
Better error hadling for ADO and MS Sql scripts
Insert and delete colums for excel and and text data source and targets
Interface Improvements
Better NULL's handling
Command line parameter transformation function was introduced

Mike
ETL Architect

Please Log in or Create an account to join the conversation.