Use query as source for file output in 12c

User_N0D2U

I need to create a mapping for which source is sql query and target is file. I created a reusable mapping with only output signature as file attributes. Then I created a main mapping and updated the query in custom template in main mapping but I am not getting any IKM to select in drop down. I do have imported IKM Sql To File Append and target integration type is Control Append in the main mapping.

Pavan8u

Hi,

You dont need to hardcode any password.

Refer link below-

Calling OdiSqlUnload using ODI Procedure with no hardcoded password - ODIExperts.com

Regards,

Pavan

Pavan8u

Hi,

You can use ODISqlUnload utility to generate file with custom sql query as input.

Regards,

Pavan

User_N0D2U

In OdiSqlUnload, I need to provide JDBC URL, username and password. I can use variables for URL and username but passwords are not shared so cannot create variable for password.

Pavan8u

Hi,

You dont need to hardcode any password.

Refer link below-

Calling OdiSqlUnload using ODI Procedure with no hardcoded password - ODIExperts.com

Regards,

Pavan