Supported Data Sources

uPlan supports the following types of data sources:

File-Based Data Sources

  • MS Access (*.mdb and *accdb)

  • MS Excel (*.xls, *.xlsx, *.xlsb, *.xlsm)

  • Note that table names must not have leading or trailing spaces, and column names must not be empty and must not have leading or trailing spaces.

  • Text Files (*.txt, *.csv)

    Note that column names must not be empty and must not have leading or trailing spaces.

  • XML (*.xml) - MS Recordset only

Server-Based Data Sources

  • mySQL - versions 4.0 and 5.0

  • Oracle 

  • MS SQL Server

  • Compact SQL Server (*.sdf)

  • IBM Informix

  • IBM DB2

  • SyBase

  • Connection String - if your data source type or version are unsupported by XMPie, you can define your own connection string.

XMPie Proprietary Data Sources

  • Counter - a proprietary XMPie data source. This single-column database is used to store sequential numbers with predefined intervals.