MySQL Sources > Introduction to MySQL catalog sources > About the MySQL catalog source
  

About the MySQL catalog source

You can use the MySQL catalog source to extract metadata from a MySQL source system.
MySQL is an open-source relational database management system (RDBMS) to store and structure data.

Extracted metadata

You can extract specific metadata from a MySQL source system with a MySQL catalog source.
Metadata Command Center extracts the following objects from a MySQL source system:

Data profiling for MySQL objects

Configure data profiling to run profiles on the metadata extracted from a MySQL source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following MySQL objects:
The data profiling task runs profiles on the following data types:
MySQL Data Type
Transformation Data Type
Description
Char
String
1 to 104,857,600 characters
Varchar
String
1 to 104,857,600 characters
Boolean
Integer
-2,147,483,648 to 2,147,483,647 (Precision 10, scale 0)
TinyInt
Integer
-2,147,483,648 to 2,147,483,647 (Precision 10, scale 0)
SmallInt
Integer
-2,147,483,648 to 2,147,483,647 (Precision 10, scale 0)
MediumInt
Integer
-2,147,483,648 to 2,147,483,647 (Precision 10, scale 0)
Int
Integer
-2,147,483,648 to 2,147,483,647 (Precision 10, scale 0)
Note:
Unsigned Int is not applicable.
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (Precision 19, scale 0)
Note:
Unsigned Bigint is not applicable.
Float
Decimal
Precision 1 to 28, scale 0 to 28
Double
Double
Precision 15
Note:
Unsigned Double is not applicable.
Decimal
Decimal
Precision 1 to 28, scale 0 to 28
Date
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (Precision to the nanosecond)
Datetime
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Timestamp
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)

Compatible connectors

Before you configure a MySQL catalog source, you must connect to the MySQL source system.
Use the MySQL connector to connect to the MySQL source system.
For information about configuring a connection, see Connections.