Data sources

Solutions relating to loading / importing data from various kinds of data sources

XML import
Importing data from XML involves configuring a File block to point to the XML file, then defining rules that map from the hierarchical structure of an XML d...
Wed, 12 Dec, 2018 at 3:03 PM
File block "Locale" option
This is an example of the effects and use case for the Locale setting in the File block. When opening a CSV file, it matters what locale it was created in. ...
Wed, 24 Apr, 2019 at 6:53 PM
Retrieving data from Salesforce using the Progress Salesforce JDBC driver
Omniscope Evo will have direct Salesforce connectivity in future. Until then, here's another way to access the data in your Salesforce account, as a reg...
Wed, 8 Jan, 2020 at 3:31 PM
Salesforce connector and output
Omniscope Evo allows you to pull the data from your Salesforce account to combine it with information coming from other sources, either to create a more com...
Tue, 21 Jul, 2020 at 2:14 PM
Connect to any SQL Database - with a JDBC driver
Omniscope Evo has the ability to load data from virtually any SQL-compatible database that comes with a JDBC driver. In order to connect and extract the d...
Wed, 29 Mar, 2023 at 10:13 AM
Setup Google Analytics connectors
Omniscope needs a OAuth2 client ID and client secret to connect to your Google Analytics data.  You will be registering your Omniscope deployment as a clie...
Sat, 19 Jun, 2021 at 4:51 PM
Set up any Google connector using OAuth Client ID and Client Secret
Omniscope needs an OAuth client ID and client secret to authenticate to your Google account in order to use a Google connector, e.g. Sheet, DoubleClick, Go...
Sat, 19 Jun, 2021 at 4:50 PM
Google BigQuery Connectivity
In Omniscope Evo it is possible to import data from, and publish data to Google BigQuery tables via community blocks. Google BigQuery Import Table all...
Thu, 14 Oct, 2021 at 3:56 PM
Amazon S3 support: Read and write S3 bucket data
Introduction Omniscope supports reading and writing data to and from an Amazon S3 bucket. An Amazon S3 bucket is a public cloud storage resource available ...
Tue, 21 Dec, 2021 at 1:16 PM
Apache Parquet read/write support
Introduction Omniscope supports reading and writing Apache Parquet files. This functionality was introduced in a daily build in December 2001, and will ...
Tue, 4 Jan, 2022 at 9:40 AM