Work with Data
You need data for any report and dashboard. Our products support a wide range of data sources – data servers, files, ADO.NET structures, business objects. Relations between data sources and data conversion are supported.Data servers
Our products support work with all popular data servers such as MSSQLServer, MySQL, ODBC, OLEDB, Oracle, MSAccess, PostgreSQL, Firebird, SQLCE, SQLite, DB2, Informix, Sybase, Teradata, VistaDB, MongoDB, OData. Also, we support the connection of your custom data adapter. Our software supports automatic detection of data types, relationships, query parameters, work with stored procedures and other features.To add a data source, select the type of data server and specify the connection string. Our report designer will request a list of available tables by itself, and after selecting the necessary tables, it will automatically create data sources in the dictionary.
Data files
Data can be loaded directly from files. We support working with XML, JSON, CSV, DBase and Excel data files. When creating a file data source, it is enough to specify the path to the file (local and remote files are supported), everything else will be done automatically – searching for columns, determining data types and table links.In addition, our product has a unique opportunity to store data in the template itself as report or dashboard resources. Simply drag and drop the file into the data dictionary area and the data source will be created automatically.