0 / 0
Importing data
Last updated: Oct 09, 2024
Importing data

Supported data sources for Synthetic Data Generator.

Using Synthetic Data Generator, you can connect to your data no matter where it lives, using either connectors or data files.

Data size

The Synthetic Data Generator environment can import up to ~2.5GB of data.

Connectors

The following table lists the data sources that you can connect to using Synthetic Data Generator.

Connector Read Only Read & Write
Amazon RDS for MySQL
Amazon RDS for PostgreSQL
Amazon Redshift
Amazon S3
Apache Cassandra
Apache Derby
Apache HDFS (formerly known as "Hortonworks HDFS")
Apache Hive
Box
Cloud Object-Storage
Cloud Object-Storage (infrastructure)
Cloudant
Cloudera Impala
Cognos-Analytics
Data Virtualization Manager for z/OS
Db2
Db2 Big SQL
Db2 for i
Db2 for z/OS
Db2 on Cloud
Db2 Warehouse
Dropbox
FTP (remote file system transfer)
Google BigQuery
Google Cloud Storage
Greenplum
HTTP
IBM Cloud Databases for MySQL
IBM Cloud Data Engine
IBM Cloud Databases for DataStax
IBM Cloud Databases for MongoDB
IBM Cloud Databases for PostgreSQL
IBM Watson Query
Informix
Looker
MariaDB
Microsoft Azure Blob Storage
Microsoft Azure Cosmos DB
Microsoft Azure Data Lake Storage
Microsoft Azure File Storage
Microsoft Azure SQL Database
Microsoft SQL Server
MongoDB
MySQL
Netezza Performance Server
OData
Oracle
Planning Analytics (formerly known as "IBM TM1")
PostgreSQL
Salesforce.com
SAP ASE
SAP IQ
SAP OData
Snowflake
Tableau
Teradata

Data files

In addition to using data from remote data sources or integrated databases, you can use data from files. You can work with data from the following types of files using Synthetic Data Generator.

Connector Read Only Read & Write
AVRO
CSV/delimited
Excel (XLS, XLSX)
JSON
ORC
Parquet
SAS
SAV
SHP
XML
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more