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.