You may see the following error message when running a data import:
Orchestrate data flow import has failed. The detailed information is as follows:
ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Import Command: N/A
Resolution
Work through the following options in order until the issue is resolved.
Option 1: Check the ODBC data source configuration
If you are importing from CSV, check that the ODBC data source is correctly configured in Orchestrate System Manager:
Log in to Orchestrate System Manager.
Select File, then select Data Import Configuration.
Select Data Source Configuration.
Click New.
Select ODBC Data Connections from the Data Source Type dropdown list.
Click Next.
Click Manage ODBC Source.
Select the System DSN tab and select the relevant name (for example, CSV Import), 32-bit, Microsoft Text Driver.
Click Configure.
Click Select Directory.
Click OK.
Option 2: Check the data flow configuration
A data sequence may be missing from the data flow, a field mapping may be missing from an existing data sequence, or the data source may be directed to the wrong database. To check the data flow configuration:
Log in to Orchestrate System Manager.
Select File, then select Data Import Configuration.
Select Data Flow Configuration.
Select CSV Import and click Edit.
Check each bulk copy into table data sequence and click Settings.
Confirm that the CSV data source is selected from the dropdown list.
Confirm that the source table contains the name of the CSV file — for example, the data sequence Bulk Copy into Table orc_Items should contain
Items.CSVin the source table field.Confirm that there is a correct source expression in the equivalent Orchestrate field name.
📌Note: If no CSV is configured, you can demonstrate how it works but cannot create all the data sequences. Setting up a full CSV configuration is chargeable consultancy — raise a self-gen case if required.
Option 3: Set up a new ODBC source and Excel/CSV import configuration
If the above options do not resolve the issue, set up a new ODBC source and configure the Excel/CSV import:
Launch ODBC from Windows.
Select the System DSN tab.
Click Add and enter a name — for example,
CSV Import.Launch Orchestrate System Manager.
Select File, then select Data Import Configuration.
Select Excel/CSV Import Configuration.
Click New, then click Next.
Select which Orchestrate table the data will import to — for example, Purchase Orders.
Click Browse to enter the source data location (the Excel workbook file).
Click Preview, then click Next.
Select Map Fields and, when complete, click Finish.
Log in to Orchestrate and select File.
Select Import, then select Import Excel/CSV Data.