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 re...
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 can load data from pretty much any SQL compatible DB that comes with a JDBC driver.   Start by adding a Database block from the Blocks men...
Mon, 17 May, 2021 at 6:37 PM
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