Data Source

Data sources are systems containing or exposing data like relational databases or APIs. The data_source table stores information about the systems to which MobyDQ can connect to compute indicators.

Note: MobyDQ only support connections to data source types described below: Data Source Type

Table: data_source

AttributeTypeDescription
idIntegerUnique identifier of the data source, used as a primary key.
nameTextName of the data source, must be unique.
connection_stringTextConnection string used to connect to the data source.
loginTextLogin used to connect to the data source.
passwordTextPassword used to connect to the data source.
connectivity_statusTextStatus to indicate if the connection to the data source works.
created_dateTimestampRecord created date.
updated_dateTimestampRecord last updated date.
created_by_idIntegerForeign key of the user table, to indicate which user created the record.
updated_by_idIntegerForeign key of the user table, to indicate which user updated the record.
user_group_idIntegerForeign key of the user_group table, to indicate to which user group the record belongs to.
data_source_type_idIntegerForeign key of the data_source_type table, to indicate which type is the data source.

Examples of Data Source: More examples of data sources are available in the sample dataset when installing MobyDQ.

AttributeValue
namedq_example_microsoft_sql_server
connection_stringdriver={FreeTDS};server=db-sql-server;port=1433;database=star_wars;tds_version=8.0;
loginsa
connectivity_statusSuccess
data_source_type_id4

Data Source Type

Data source types describe the type of systems MobyDQ can connect to.

Table: data_source_type

AttributeTypeDescription
idIntegerUnique identifier of the type of data source, used as a primary key.
nameTextType of data source, must be unique.
created_dateTimestampRecord created date.
updated_dateTimestampRecord last updated date.
created_by_idIntegerForeign key of the user table, to indicate which user created the record.
updated_by_idIntegerForeign key of the user table, to indicate which user updated the record.

List of Data Source Type Values

idname
1Hive
2Impala (to be supported soon)
3MariaDB
4Microsoft SQL Server
5MySQL
6Oracle (to be supported soon)
7PostgreSQL
8SQLite
9Teradata