How do I swap between Live and Test Directories to run the relevant CSV data import.
Your live database is already setup with an ODBC connection to the relevant network drive (that contains the live CSV files). Now, complete the following steps to connect to the play system:-
Log into Orchestrate System Manager and make sure the play database is selected.
Select file.
Select data import configuration.
Select data source configuration.
Click New.
Select ODBC data connections from Data Source Type dropdown list.
Click Next.
Click Manage ODBC source.
Select System DSN tab and select the relevant name e.g. CSV import, 64 bit, Microsoft Access Text driver.
Click Configure.
Click Select Directory e.g. network drive mapping where all the test CSV files are stored.
Click OK.