DbDataSource Object

The DbDataSource object represents an external file in database format.

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
Delete Method	Deletes the DbDataSource object.
Move Method	Moves the DbDataSource object to a different position in the DataSources collection.
Update Method	Updates the DbDataSource object.

Property	Description
Application Property	Returns the Transformer Application object.
Columns Property	Returns a Columns collection.
ColumnsLoaded Property	Returns whether the columns in a data source have been used to build a model.
DataRange Property	Sets or returns the name of a database range in the data source.
DecimalPoint Property	Sets or returns the separator character used for a decimal point.
Description Property	Sets or returns the description of the DbDataSource object.
External Property	Sets or returns whether values in the data source are treated as summarized or rolled up when used by the model.
GenerateCategories Property	Sets or returns whether categories are generated for the data source.
GeneratePowerCube Property	Sets or returns when a data source is referenced by a model.
IsAnyColumnMismatched Property	Returns whether columns in the data source match the underlying data.
LocalPath Property	Sets or returns the location of the local data source.
MaximizeSpeed Property	Sets or returns whether category generation is optimized for speed.
Name Property	Sets or returns the unique name for the data source.
Parent Property	Returns the parent object.
ServerPath Property	Sets or returns the name and location of a data source file.
ServerQuery Property	Returns whether data is processed locally or on a server.
SetsCurrentPeriod Property	Sets or returns whether Transformer searches a data source to find the current period date.
SourceType Property	Sets or returns the type of data file a data source uses.
ThousandPoint Property	Sets or returns the character used to separate numbers in thousands.
Type Property	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.