Sharperlight – Data Sources

​Sharperlight data access will in most cases be via Datamodels that connect to a Ralational Database such as Microsoft SQL Server, Oracle or DB2 for example.  There are other sources for data that include Web Services, Web Pages, RSS Feeds, JSON, LDAP, CVS files and Excel Workbooks etc that can be found under the System Datamodel.

There are also Datamodels developed to read data from Web Services or RESTful services and depending on the requirments cache the data locally for reporting.

Relational Databases

Please Note:

If the database you wish to connect to is not in the list and it has a OLE DB or .NET Data Provder then it is possible to create your own connection string properties and template.  It is recommend that you select a connection type like SQL Anywhere then modifiy the properties and Connection Template details to suit the driver selected.  SQL Syntax Templates also exist where you may need to specifiy the SQL syntax used by that system for various functions such as Substrings and Date converts.  When it comes time to import the schema you will notice​​ that you can define your own SQL to read the tables and fields to best suit the target platform.

Studio – New Datamodel Screen 

System Other Data Sources

• Query Builder – System Datamodel Table List