Import SQL Server Functions to BODS all at once

[former_member190674]

I have about 200 to 250 functions in sql server database which I would like to import to my BODS Local Repo all at once. Is there any other way than importing using "Import By Name.." option?

Regs/Santhosh

[Former Member]

you can use al_engine command to import the functions, check the following option

-FDatastoreName.OwnerName.FunctionName

[chethan_lingaraju]

Yup, we generate commands in excel.

[former_member224495]

Hi Santhosh,

Same thing we have done for tables.

We followed the below procedure

1.Go to data store

2.Double click on tables(Header)

3.Right side panel Under External Metadata you will get created tables under data stores.

4.Select all tables and right click and select import.

Please apply same procedure for functions and let us know if it works.

Thanks,

Sagar T

[former_member187605]

That approach will only work for tables (and views). From the DS Designer, functions can only be imported by name.

But you can use the command line interface to automate your process.