- Posts: 50
- Thank you received: 0
Can command line take input parameters
12 years 1 week ago - 12 years 1 week ago #3897
by Allen
Can command line take input parameters was created 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?
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.
12 years 1 week ago #3900
by admin
Mike
ETL Architect
Replied by admin on topic Re: Can command line take input parameters
Sounds like a good idea.
We will add it to the next release
Mike
We will add it to the next release
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
12 years 1 week ago #3908
by Allen
Replied by Allen on topic Re: Can command line take input parameters
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.
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.
12 years 1 week ago #3912
by admin
Mike
ETL Architect
Replied by admin on topic Re: Can command line take input parameters
Can you tell us more about what you are trying to achieve maybe there is a better solutions..
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
12 years 1 week ago #3920
by Allen
Replied by Allen on topic Re: Can command line take input parameters
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.
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.
12 years 5 days ago #3928
by admin
Mike
ETL Architect
Replied by admin on topic Re: Can command line take input parameters
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
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.