CONNECT subcommand (GET DATA command)

The CONNECT subcommand identifies the database source. The recommended method for generating a valid CONNECT specification is to initially use the Database Wizard and paste the resulting syntax to a syntax window in the last step of the wizard. See the topic To Read Database Files for more information.

• The entire connect string must be enclosed in quotation marks.
• For long connect strings, you can use multiple quoted strings on separate lines, using a plus sign (+) to combine the quoted strings.

Example

GET DATA /TYPE=ODBC 
  /CONNECT=
 'DSN=MS Access Database;DBQ=/examples/data/dm_demo.mdb;'+
 'DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
 /SQL = 'SELECT * FROM CombinedTable'.

Connection Pooling

If you access the same database source multiple times in the same job, you can improve performance with connection pooling. At the end of the quoted CONNECT string, add Pooling=true.