Using Connectors

Connecting to Remote Data

Access, visualise, refresh, edit, archive and share copies of remote-hosted or 'cloud-based' data

Connectors enable Omniscope to access data sources other than delimited data files or relational databases permitting connections to tables/reporting views using ODBC or JDBC. There are two types of connectors; direct connectors which log into services directly from Omniscope, and web (services) connectors you add into your online services accounts that deliver your data to Omniscope on your desktop.

Note: Connectors for accessing and synchronising with remote-hosted data and service 'clouds' are available only from activated Omniscopes, not the free Viewer.

Bloomberg Connector

Activated Omniscope editions can import, save and refresh data from Bloomberg using the commands Data > Import from Bloomberg to define the fields (columns) to be added to the file. To refresh on demand with the latest real-time data from Bloomberg, use Data > Refresh from Source or Ctrl+F5. If you send the file to others with access to Bloomberg, the file will refresh from Bloomberg on opening, assuming refresh behavior has been set to 'Always'. More on using Omniscope with Bloomberg.

Email Connector

Omniscope 2.5 and above include the ability to download email in accounts from providers that support either POP3 or IMAP protocols.
How to use the Omniscope Email connector

Google Spreadsheets

Google spreadsheets are on-line collaborative tools for gathering and maintaining structured data sets.

How to use Omniscope with Google Spreadsheets

Facebook

Facebook is a social networking application that allows users to create networks of relationships centred on their accounts.

How to use Omniscope with Facebook

Google Analytics

The Google Analytics import function allows you to download and analyse Google Analytics data from within Omniscope.

How to use Omniscope with Google Analytics

Web Mapping

A web site map is a network of interconnecting pages within a particular website. A connection between two pages exists if the first page contains a link to the second page. You can use the webmap functionality within Omniscope to visualise the structure of a website.

How to use Omniscope for Web Site Mapping

Salesforce/Force.com Connector

Salesforce is an application that runs in the Force.com online cloud-computing hosted platform, one of the largest and fastest-growing general-purpose SaaS platforms. Salesforce is widely used for CRM (Customer Relationship Management, composed of the 'Sales Cloud' and service/case management, aso know as the 'Service Cloud'). Almost any application can be written on the Force.com platform. If you have a Salesforce account, it is possible to access your Reports and Data Objects/Tables stored in Salesforce using either the Omniscope direct connector (File > Open online source > Salesforce) or the free web connector your Administrator can install into your Salesforce account from the online AppExchange.

Salesforce web connector: the free Omniscope Connector for Salesforce web service can be installed in your Salesforce account(s) from the AppExchange listing page by your Administrator, unless you have a Group Edition. Instructions for installing in Group Editions are here. The web connector installation will add a new tab from which you can download reports and un-joined data objects using pre-configured templates to deliver files that will open in the free Viewer. An activated version of Omniscope is required to modify and save customised templates, which can then be uploaded to your account, adding new download and viewing options for different classes of users within your organisation. More on using the online Web Connector for Salesforce.

Salesforce direct connector: Omniscope Professional and Enterprise 2.5 (and later) enable to access your Salesforce reports and data objects directly. More on using the Direct Connector for Salesforce to access, modify, edit and synchronise changes with your Salesforce-hosted data.

More detail and a solutions roadmap for making the most of the combination of Salesforce and Omniscope is here.

Open folder of files

Open image set

Experimental Connectors

GoogleBase Connector

(experimental feature)

Amazon.com Connector