Integration with UniVerse database

[Jaganath]

Hi Everyone,

Good day. Just checking here. My client has given a hint that they have the data stored UniVerse database. Does anyone know how to integrate with fabric and extract the data seemlessly. I will get the detailed requirements soon. However, just wanted to check if this integration is possible with fabric.

Appreciate your help here.

Thanks,

Jaganath

[Andaman]

integration with UniVerse database and Microsoft Fabric is possible. You can use SQL Server Management Studio or Azure Data Explorer to connect and extract data seamlessly Databases in Fabric - 7 Quickstart tips - Microsoft Fabric Community

[Jaganath]

Hi @Andaman ,

Thank you for following up on this. It is great to know this is possible! However, I would like to clarify a few points:

1. Are you suggesting that SSMS or ADE can directly connect to the UniVerse database to extract data? My understanding is that UniVerse is an MVDBMS, so I am curious about how this integration works.

2. Is there a way to bypass SSMS or ADE and directly push the data into Fabric?

I appreciate your insights on this.

Thanks,
Jaganath

[Anonymous]

HI @Jaganath,

I checked these on fabric side but not found the official data connectors. For this scenario, perhaps you need to use REST API or other type of data drivers with connection string to get data.

Regards,

Xiaoxin Sheng

[Jaganath]

Hi @Anonymous ,
Thanks for checking. Much appreciated.

[Anonymous · Accepted solution]

Hi @Jaganath,

Here is some code about jdbc driver in notebook that modify from sample of other datasource, you can take a look on it if helps: (notice: you need to upload the driver file to the environment before use these)

from pyspark.sql import SparkSession

#Initialization SparkSession
spark = SparkSession.builder \
    .appName("UniVerseConnection") \
    .config("spark.driver.extraClassPath", "/path/to/your/uploaded/UniVerse") \
    .getOrCreate()

#Use a JDBC connector to connect to the UniVerse database
jdbc_url = "jdbc:universe://hostname:port/database"

#Configure the connection string with credentials and database details
connection_properties = {
    "user": "your_username",
    "password": "your_password",
    "driver": "com.universe.jdbc.Driver"
}

#Use the Spark DataFrame to read data
df = spark.read.jdbc(url=jdbc_url, table="your_table_name", properties=connection_properties)
df.show()

Regards,

Xiaoxin Sheng