A Data Source is an object that defines the information Clarify needs to connect to a single database. It also specifies which tables, views, and columns Clarify can interact with.
- The JDBC Driver to use when connecting to the database
- The database's URL
- The username and password to use when connecting to the database
- The tables, views, and columns that Clarify must read, write, update, or delete
If any of the data involved in transformation comes from or goes to a database and you want Clarify to interact with the database directly, you must use a Data Source.
Clarify uses Data Sources to interact with databases.
- Database Adapters
- Database Monitors
- SQL Access objects
Data Sources exist independently and, once created, should remain fairly static. A single Data Source can be referenced by multiple objects, including multiple objects of the same type across multiple Projects.
However, you might want to use multiple Data Sources to access the same database if you have multiple Database Schemas referring to the same database but using different tables, views, and/or columns. Although you can specify which tables, views, and columns to use in a Schema, you may have to repopulate that Schema from the Data Source if you ever make changes to the actual database. In that instance, you would have to remove any extra tables, etc. that come over from the Data Source that you aren't using in the Schema.
Clarify includes - and recommends using - the Database Refresh Wizard to streamline any changes to Data Sources and their affected Schemas and Adapters.
- Create a Data Source in your Package.
- Specify the information Clarify needs to connect to the database in its editor.
- Specify which tables and columns Clarify will be using.
- Reference the Data Source in the appropriate objects that ask for it (Database Adapters, Monitors, etc.)