Welcome
Explore Data Integration. Connect different data sources and various stages used in Data Integration process.
Introduction
Learn about data management architecture and the star schema data warehouse design.
Connecting to Data Sources and Data Warehouses
Connect to different types of data sources.
- Connections
- Spectrum Supported Data Sources
- Defining Connections
  - Connecting to Amazon
  - Connecting to Apache Cassandra
  - Connecting to Azure Cloud
  - Connecting to a Flat File
  - Connecting to an FTP Server
  - Connecting to an SFTP Server
  - Connecting to Google Cloud Storage
  - Connecting to Hadoop
  - Connecting to Hive
  - Connecting to a JDBC Database
    - Importing a JDBC Driver
      If Spectrum Technology Platform does not have a driver for your database, you can add a JDBC driver to access data in the database.
    - Manually Adding a JDBC Driver
    - Deleting an Imported JDBC Driver
    - Supported Database Data Types
    - Supported Database Data Types for Spectrum Spatial
    - JDBC Database connector limitations
  - Connecting to Knox
  - Connecting to a Windows Mapped Drive
  - Connecting to Marketo
  - Connecting to Microsoft Dynamics 365
  - Connecting to a Model Store
  - Connecting to NetSuite
  - Connecting to NoSQL
  - Connecting to Salesforce
  - Connecting to SAP NetWeaver
  - Connecting to SharePoint
  - Connecting to Splunk
  - Connecting to Oracle Eloqua
- Compression Support for Cloud File Servers
- Deleting a Connection
Populating the Data Warehouse
Prepare your data for warehouse. Populate Time Dimension table, Dimension table, Fact table. Add time stamp to records in a Data Warehouse.
Updating the Data Warehouse
Define a Data Warehouse update schedule. Update a fact table. Use Global and Local cache for queries.
Accessing Stages Through Enterprise Designer
Access different stages through Enterprise Designer.
Configurations
Configure Oracle LogMiner, and HDFS connection for HA Cluster.
Optimizing Performance
Improve performance by determining an optimum fetch size. Learn about best practices for connecting to HDFS 3.x and Hive 2.1.1.

Deleting an Imported JDBC Driver

JDBC drivers cannot be deleted using Spectrum Management Console if the JDBC driver was imported to Spectrum Technology Platform rather than being added manually in Spectrum Management Console. Instead, follow this procedure to delete the driver.

Important: Before deleting a driver, verify that there are no database connections using the driver.

Stop the Spectrum Technology Platform server.
Go to this folder:

SpectrumDirectory\server\drivers
In the drivers folder, delete folder containing the driver.
Start the Spectrum Technology Platform server.
To verify that the driver has been deleted, log in to Spectrum Management Console, go to System > Drivers, and verify that the driver is no longer listed.