When designing integrations for Actian Warehouse (formerly Avalanche Warehouse), do not use DSNs, because they are not defined in the cloud environment. This applies when you want to use Actian Warehouse as an integration source and target in transformations for SQL sessions and in EZscript with DJImport.

 

Instead of DSNs, always use the native login ODBC connection string that is provided in your Actian Warehouse Connections page. For more information about Actian Warehouse connector, see Actian Warehouse. For more information about Actian Warehouse Connections Page, see Actian Data Platform (formerly Avalanche) help.

To be able to select a driver instead of a DSN name, first set the parameter DSNType=Driver in the properties field. Then you select the 'Actian' driver in the dropdown of the field to the left named 'Database' or 'Source Data Source' or 'Target Data Source', depending on the respective dialog.

In the properties field set ModifyDriverOptions to false. Put the ODBC connection string of the DriverOptions property into a macro to avoid redundancies when changing the warehouse.

Please note that when using the DJImport object, for the DriverOpts parameter, the ODBC connection string must be placed in single quotes.

The DJImport wizard may give you an error when tested without a DSN. But you can still save your connection string. When this connection string is used in an EZscript it will work locally as well as in the cloud. For more information about DJImport object type, see DJImport and DJExport Object Types, Creating New DJImport or DJExport Object and Using Existing DJImport or DJExport Object.