Connectors
LucidDB takes a unique, simple approach to external data: make remote data into Tables and accessible via SQL. Our connection technology presents remote data, be they web services, flat files, PDI transformations, or other databases to users as Schemas, Tables, and Columns. You can find new connectors from our Downloads area, community sites, or write your own!
Real Time Data Federation
Some reports need access to data in the reporting system, but also require “up to the second” access to data in other systems – often time these systems can’t even talk SQL with your reporting tool!
- You can author real time reports that join data from LucidDB (customer lifetime value, historical orders, etc) with data from Salesforce (customer support cases currently open).
- Join data from separate databases (Oracle, MySQL, etc) and use the full power of ANSI SQL to prepare the data for your report.
- Many connectors, when remote protocols support it, do intelligent push down filtering (only get records Oracle where CUSTOMER_TYPE = Deactivated and LAST_ACTIVE between Jan 01 and Jan 31).
Easy Access for Loading
- Remote data presents itself as Tables/Columns, it’s available for our advanced but simple data loading.
- Eliminates the need to stage/temporarily store data from remote systems prior to loading. Data goes effeciently from source to target.
- Push down filters to source systems to update “just the data that has changed” since the last time a load was processed. We can ask your foreign source for just data that has changed since the last time you loaded the data.
