Collibra Community

JDBC drivers

Created Sep 3, 2024

1 member

2 discussions

The JDBC Drivers topic in the Collibra Community is focused on helping users connect Collibra to various databases using JDBC. Discussions include setting up metadata connections, handling authentication methods like managed identities, and troubleshooting connection string errors—key for teams integrating data sources into the platform.

venkatreddy_maddi
2 months ago
Has any one implemented metadata connection in Edge for Postgress using managed identity based authentication?
Has any one implemented metadata connection in Edge for Postgress using managed identity based authentication?

0
Matheus_ha
7 months ago
Cant connect Collibra to SQL Intanced Server
Hello, we are trying to connect Collibra to a instance in our SQL Server with the jdbc string: jdbc:sqlserver://{SERVER}\{INSTANCE}:{PORT};databaseName={DATABASE};encrypt=true;trustServerCertificate=true, but it keeps returning this error: Unexpected error running test connection Test jdbc connection failed. com.collibra.edge.connection.capability.ConnectionTestException: Test jdbc connection failed at com.collibra.edge.connection.capability.jdbc.JdbcConnectionTestExecutor.executeTest(JdbcConnectionTestExecutor.java:40) at com.collibra.edge.connection.capability.EdgeTestConnectionCapability.lambda$main$0(EdgeTestConnectionCapability.java:30) at java.base/java.util.Optional.map(Optional.java:260) at com.collibra.edge.connection.capability.EdgeTestConnectionCapability.main(EdgeTestConnectionCapability.java:30) Caused by: java.lang.RuntimeException: java.lang.NullPointerException: Cannot invoke "java.sql.Connection.isReadOnly()" because "this.delegate" is null at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:49) at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:22) at com.collibra.edge.sdk.ParameterHandler.connectToJdbc(ParameterHandler.java:201) at com.collibra.edge.sdk.EdgeRuntime.connectToJdbc(EdgeRuntime.java:123) at com.collibra.edge.sdk.EdgeRuntime.connectToJdbc(EdgeRuntime.java:117) at com.collibra.edge.connection.capability.jdbc.JdbcConnectionTestExecutor.executeTest(JdbcConnectionTestExecutor.java:28) ... 3 more Caused by: java.lang.NullPointerException: Cannot invoke "java.sql.Connection.isReadOnly()" because "this.delegate" is null at edge.com.collibra.jdbc.connection.DelegatingConnection.isReadOnly(DelegatingConnection.java:96) at com.collibra.jobserver.edge.DelegatingConnection.isReadOnly(DelegatingConnection.java:96) at edge.com.collibra.jdbc.connection.readonly.ReadOnlyConnectionDecoratorFactory$ReadOnlyConnectionDecorator.<init>(ReadOnlyConnectionDecoratorFactory.java:44) at edge.com.collibra.jdbc.connection.readonly.ReadOnlyConnectionDecoratorFactory.decorate(ReadOnlyConnectionDecoratorFactory.java:32) at edge.com.collibra.jdbc.connection.DefaultJdbcClient.createConnection(DefaultJdbcClient.java:268) at edge.com.collibra.jdbc.connection.DefaultJdbcClient.connect(DefaultJdbcClient.java:83) at com.collibra.edge.sdk.ParameterHandler.lambda$connectToJdbc$2(ParameterHandler.java:201) at com.collibra.edge.sdk.Retryable.lambda$executeWithRetry$0(Retryable.java:25) at com.collibra.edge.sdk.Retryable.executeWithRetry(Retryable.java:39) ... 8 more We already connected SQL server that dont have instances with the same user and it worked. Can someone help me on this please?

1

Has any one implemented metadata connection in Edge for Postgress using managed identity based authentication?

Cant connect Collibra to SQL Intanced Server

Has any one implemented metadata connection in Edge for Postgress using managed identity based authentication?

Cant connect Collibra to SQL Intanced Server