Database connections are reusable objects. Create them once, test them, and use them across imports, exports, transformations, and workflows.
What You Will Learn
- Create a database connection object.
- Test connection settings before using them in a package.
- Reuse connections across transformations and workflows.
- Keep connection setup separate from transformation design.
Before You Start
Have the database server name, credentials, and target database ready. Guessing connection strings is a traditional way to lose an afternoon.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.