DbDataSource Object
Discussion
Use this object to connect to an external file in database format.
To create a DbDataSource object, use the Add method of the DataSources collection. Ensure that you set the Type parameter to the trDbDataSource constant. Set the SourceType property to the type of database file to open. Use the LocalPath and ServerPath properties, as applicable, to give the location of the data file.
DbDataSource objects contain a Columns collection. Columns are the source for levels in a dimension.
Transformer can use database information from the following:
- dBase
- Excel
- Access
- Paradox
- FoxPro
- Clipper
For example, you can use this property to specify a table from an Access database (.mdb).
You can use an Access query that points to an ODBC data source to get server-based data into Transformer. If you use an Access query as a source, the Columns collection is derived from the SQL query that references the database.
If you use Paradox tables with a sorting key other than ASCII, which is the default setting in the Jet engine for Paradox, you must include the primary index file (.px) in the same location as the Paradox database file (.db) before importing the tables. You must also modify the Windows registry key to a value corresponding to the sorting key used when creating the table. Valid values are
- ASCII
- International
- Norwegian-Danish
- Japanese
- Swedish-Finnish
To save changes to the properties of this object, use the Update method.
Related Topics
These tables list related collections, methods, and properties.
Method |
Description |
---|---|
Deletes the DbDataSource object. |
|
Moves the DbDataSource object to a different position in the DataSources collection. |
|
Updates the DbDataSource object. |
Property |
Description |
---|---|
Returns the Transformer Application object. |
|
Returns a Columns collection. |
|
Returns whether the columns in a data source have been used to build a model. |
|
Sets or returns the name of a database range in the data source. |
|
Sets or returns the separator character used for a decimal point. |
|
Sets or returns the description of the DbDataSource object. |
|
Sets or returns whether values in the data source are treated as summarized or rolled up when used by the model. |
|
Sets or returns whether categories are generated for the data source. |
|
Sets or returns when a data source is referenced by a model. |
|
Returns whether columns in the data source match the underlying data. |
|
Sets or returns the location of the local data source. |
|
Sets or returns whether category generation is optimized for speed. |
|
Sets or returns the unique name for the data source. |
|
Returns the parent object. |
|
Sets or returns the name and location of a data source file. |
|
Returns whether data is processed locally or on a server. |
|
Sets or returns whether Transformer searches a data source to find the current period date. |
|
Sets or returns the type of data file a data source uses. |
|
Sets or returns the character used to separate numbers in thousands. |
|
Returns the object type. The object type returned is trDbQuery even though the xtrObjectType.trDbDataSource type must be used to add and retrieve an item from the DataSources collection. |