0 / 0
Creating synthetic data from imported data
Last updated: Dec 12, 2024
Creating synthetic data from imported 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.

Important: If you import a flow, some nodes might not be supported or work as expected.

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 Notes
Amazon RDS for MySQL Replace the data set option isn't supported for this connection.
Amazon RDS for PostgreSQL Replace the data set option isn't supported for this connection.
Amazon Redshift
Amazon S3
Apache Cassandra
Apache Impala
Apache Derby
Apache HDFS (formerly known as "Hortonworks HDFS")
Apache Hive
Box
DataStax Enterprise
Dremio
Dropbox
FTP (remote file system transfer)
Google BigQuery
Google Cloud Storage
Greenplum
HTTP
IBM Cloud Object-Storage
IBM Cloud Object-Storage (infrastructure)
IBM Cloud Data Engine
IBM Cloud Databases for MongoDB
IBM Cloud Databases for MySQL
IBM Cloud Databases for PostgreSQL
IBM Cloudant
IBM Cognos-Analytics
IBM Data Virtualization Manager for z/OS
IBM Db2
IBM Db2 Big SQL
IBM Db2 for i
IBM Db2 for z/OS
IBM Db2 on Cloud
IBM Db2 Warehouse
IBM Informix
IBM Netezza Performance Server
IBM Planning Analytics (formerly known as "IBM TM1") Only the Replace the data set option is supported.
IBM Data Virtualization
IBM watsonx.data Presto
Looker
MariaDB
Microsoft Azure Blob Storage
Microsoft Azure Cosmos DB
Microsoft Azure Databricks
Microsoft Azure Data Lake Storage
Microsoft Azure File Storage
Microsoft Azure SQL Database
Microsoft SQL Server SQL pushback isn't supported when Active Directory is enabled.
Microsoft Azure Synapse Analytics
MongoDB
MySQL
OData
Oracle
PostgreSQL
Salesforce.com
SAP ASE
SAP IQ
SAP OData
SingleStoreDB
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.

Important: If your .cvs file contains any malicious payload (formulas for example) in an input field, these might be executed.
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