DataCap is integrated software for data transformation, integration, and visualization. Support a variety of data sources, file types, big data related database, relational database, NoSQL database, etc. Through the software can realize the management of multiple data sources, the data under the source of various operations conversion ...
Home Page: https://datacap.devlive.org/
License: Apache License 2.0
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "github-actions[bot]")
Support for viewing build statement sentences
None
No response
server or web themes
For MySQL
Querying the sys.host_summary table (this is a view) results in a value that cannot be converted
Querying the sys.host_summary table
None
None
java 11.0.2 2019-01-15 LTSv18.18.29.8.11.16.0+NoneMac OSMicrosoft Edgeserver or web themes
No column information is returned when the data is empty
Column information is returned correctly when the data is empty
Column information is returned correctly when the data is empty
MetadataData tabsjava 11.0.2 2019-01-15 LTSv18.18.29.8.11.16.0+NoneMac OSMicrosoft EdgeTo facilitate problem feedback, add the version number of the current software to the current system
To facilitate problem feedback, add the version number of the current software to the current system
No response
In the user configuration, ChatGPT is currently unable to associate the context
The content submitted will be reset every time. I hope to provide a function similar to the official website. You can reply by recording the context.
查询界面-左侧数据源下拉框可以添加一个模糊搜索框
Query Interface - The left data source drop-down box allows you to add a fuzzy search box
查询界面-左侧数据源下拉框可以添加一个模糊搜索框
Query Interface - The left data source drop-down box allows you to add a fuzzy search box
No response
支持多个窗口
null
none
server or web themesCannot init RedisConnection cannot init redisconnection The account password is correctly configured
You can use the Redis data source
Not working
Add the Redis connection source configuration
1.81671.0.0.20221015NoneLinuxChromeserver or web themes两个Tab会自动合并，导致之前的Tab内容丢失。
不要自动合并
新建Tab A，写好脚本，运行。
新建Tab B，写好脚本，运行。
再回到Tab A，发现回不去了，两个Tab的内容都是Tab B的内容。
111111444
111111333
1111112211111122
server or web themes2023-05-07 05:58:01,243 DEBUG [http-nio-9096-exec-7] org.apache.commons.beanutils.converters.BooleanConverter [AbstractConverter.java:140] Converting 'Boolean' value 'false' to type 'Boolean'
2023-05-07 05:58:01,244 DEBUG [http-nio-9096-exec-7] org.apache.commons.beanutils.converters.BooleanConverter [AbstractConverter.java:162] No conversion required, value is already a Boolean
2023-05-07 05:58:01,244 DEBUG [http-nio-9096-exec-7] org.apache.commons.beanutils.converters.IntegerConverter [AbstractConverter.java:140] Converting 'Integer' value '30307' to type 'Integer'
2023-05-07 05:58:01,245 DEBUG [http-nio-9096-exec-7] org.apache.commons.beanutils.converters.IntegerConverter [AbstractConverter.java:162] No conversion required, value is already a Integer
2023-05-07 05:58:01,246 DEBUG [http-nio-9096-exec-7] org.apache.commons.beanutils.converters.StringConverter [AbstractConverter.java:140] Converting 'String' value '192.168.233.20' to type 'String'
2023-05-07 05:58:01,246 INFO [http-nio-9096-exec-7] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:70] Connection driver com.mongodb.jdbc.MongoDriver
2023-05-07 05:58:01,247 INFO [http-nio-9096-exec-7] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:71] Connection url jdbc:mongodb://192.168.233.20:30307?authSource=admin
2023-05-07 05:58:01,247 INFO [http-nio-9096-exec-7] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:73] Connection username with admin password with ***
2023-05-07 05:58:01,250 ERROR [http-nio-9096-exec-7] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:87] Connection failed
java.sql.SQLException: java.lang.IllegalArgumentException: The connection string contains options without trailing slash
at com.mongodb.jdbc.MongoDriver.getConnectionSettings(MongoDriver.java:370)
at com.mongodb.jdbc.MongoDriver.getUnvalidatedConnection(MongoDriver.java:193)
at com.mongodb.jdbc.MongoDriver.connect(MongoDriver.java:165)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
配置主机IP，端口，后日志输出错误提示无法正确连接到mongodb
配置主机IP，端口，后日志输出错误提示无法正确连接到mongodb。必然出现
1，数据源管理
2，添加数据源
3，选择mongodb
4，配置主机，端口。自定义认证authsource=admin
docker run -d -p 9909:9096 --name datacap qianmoq/datacap
无Supports cloning row data
Supports cloning row data
No response
在tab A中格式化了脚本，再点击Tab B，再回到Tab A,Tab A中原本格式化的脚本又恢复原样了。
11
1
server or web themes设置MySQL数据源，“高级-数据库”字段必须带一个？结尾才可以正常设置成功，否则就设置失败，提示“unkown database xxxx”
可以正常设置数据库
设置MySQL数据源，“高级-数据库”字段必须带一个？结尾才可以正常设置成功，否则就设置失败，提示“unkown database xxxx”
数据源-选择MySQL数据库
系统配置能支持sql保存并支持创建文件夹分类保存就更好了
能支持sql保存并支持创建文件夹分类保存就更好了
Support jdbc driver
Support jdbc driver
No response
server or web themesThe 'keyword' is repeated with tab page addition
The keyword does not appear repeatedly
The keyword is repeated
null
java --versionnode --versionnpm -v./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -1nullserver or web themes创建A Tab，查出内容 AContext。
再创建B Tab，查出内容BContext。
再回到A Tab，结果栏出依旧显示BContext。需要重新执行A Tab脚本，才能再看到AContext。
bug
bug
java --versionnode --versionnpm -v./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -11Supports custom column display
Supports custom column display
No response
Support Phoenix(HBase SQL)
Support Phoenix(HBase SQL)
Support Phoenix(HBase SQL)
Support add new row data
Support add new row data
No response
If you and your company or organization use DataCap, thank you very much for your support and feel free to leave your company or product name. Your response will be a source of confidence for maintainers, community users, and observers.
⚠️ Irrelevant replies will be cleared and deleted daily
⬆️ The information you provide will be displayed in Powered By
Your avatar: xxxxx
Your name: xxxxx
Type:Personal|Project|Company
Your Description : xxxxx
Your personal connection: xxxxx
如果您和您的公司或组织使用了 DataCap ，非常感谢您的支持，欢迎留下公司或产品名，您的回复将成为维护者、社区用户和观望者的信心来源。
⚠️ 无关回复将会每日清理删除
⬆️ 您提供的信息将会展示在 Powered By
您的头像: xxxxx
您的名字: xxxxx
类型:个人|项目|企业
您的描述 : xxxxx
连接信息: xxxxx
Support DuckDB on datacap
No response
server or web themes程序在进行登陆等操作时，将密码等敏感信息使用 HTTP 进行明文传输。攻击者
可以通过捕获网络流量利用该漏洞获取用户的密码并登录帐户。
敏感数据在传输过程中应该以密文形式存在
敏感数据在传输过程中以明文形式存在
以登陆界面为例
1.打开 Wireshark，截取 http 报文
2.在登陆界面输入演示账号与密码进行登录
3.找到登录发送的 POST 请求报文，查看负载信息即可获得数据
无
无-- 查看建库语句
show create database A
-- 删除数据库
drop database A
能支持以上操作就更完美了
-- 查看建库语句
show create database A
-- 删除数据库
drop database A
No response
sql输入框有多个sql，注释掉下面sql，执行上面sql时，显示异常，会把数据显示在表头
Unify the data types returned by each plug-in
None
No response
server or web themesredis mget,hget 值显示为null
redis mget,hget 值按list展示
redis mget,hget 值按list展示
null
java --versionnode --versionnpm -v./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -1nullserver or web themes后台服务报错如下
2023-07-11 17:43:37,717 ERROR [http-nio-9096-exec-8] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:82] Connection failed
java.sql.SQLException: Connection failed.
Caused by: java.util.concurrent.ExecutionException: com.mongodb.MongoCommandException: Command failed with error 59 (CommandNotFound): 'no such command: 'sqlGetResultSchema'' on server 10.28.149.244:27017. The full response is {"ok": 0.0, "errmsg": "no such command: 'sqlGetResultSchema'", "code": 59, "codeName": "CommandNotFound"}
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at com.mongodb.jdbc.MongoConnection.testConnection(MongoConnection.java:510)
at com.mongodb.jdbc.MongoDriver.connect(MongoDriver.java:171)
... 107 common frames omitted
Caused by: com.mongodb.MongoCommandException: Command failed with error 59 (CommandNotFound): 'no such command: 'sqlGetResultSchema'' on server 10.28.149.244:27017. The full response is {"ok": 0.0, "errmsg": "no such command: 'sqlGetResultSchema'", "code": 59, "codeName": "CommandNotFound"}
mongodb支持jdbc连接吗，是不是mongodb-jdbc驱动包版本2.0.2的问题，mongodb有可用的jdbc最新驱动包吗
连接成功，可以创建mongodb数据库连接
页面报错，弹框展示 Connection failed
1.创建mongodb连接
2.配置ip和端口，密码，数据库
3.点击测试连接
java --versionnode --versionnpm -v./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -1server.port=9096
# Forwarding system preset related errors to custom processing
spring.mvc.throw-exception-if-no-handler-found=true
spring.resources.add-mappings=false
spring.web.resources.add-mappings=true
# Set env for datasource
# 去掉&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT'
spring.datasource.url=jdbc:mysql://10.21.xx.xx:3306/cdc?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false&useOldAliasMetadataBehavior=true&jdbcCompliantTruncation=false
spring.datasource.username=cdc
spring.datasource.password=xx
datacap.security.secret=DataCapSecretKey
datacap.security.expiration=86400000The code editor supports automatic prompts for data source library tables and columns
Support pipeline drag mode
None
No response
复制查询结果，需要点击四次才可以，麻烦。
不能全选查询结果，无法全部复制。
111
111
Support column filter for metadata
Support column filter for metadata
No response
server or web themes浏览器：
版本：1.16.0
问题1：查询功能 - sql编辑器没有出现，无法编辑sql，去个人中心更新编辑器以后解决此问题
问题2：管理/历史 - 报错，删除audit_plugin表的plugin_id=9的数据后解决此问题
fixbug
null
nullSupport aliyun oss on datacap
https://www.aliyun.com/product/oss
No response
The code editor supports code fragments
Support reset auto increment
Support reset auto increment
No response
clickhouse Query the same query sql statement
DataCap on Docker ：query time：3414ms，
CloudBeaver on Docker：query time：147ms
The guess is that the datacap front-end needs to render a large result set.
select
*
from
sjjsq_db.dwa_szh_cw_jx
Unavailable in unsupported areas, unable to link api.openai.com error
增加一个反馈问题的地方，或者可以直接跳转到该提issue的地方。
No response
Support for chart editor
None
No response
希望出现自动提示后，可以通过类似点击空格键，取消自动提示。不然一回车，自动提示的内容就写入编辑板，还得删除，麻烦。
No response
Support Oracle
Support Oracle
No response
server or web themesOur online resource is SSL, and the software failed to configure the connection
Juxt add SSL support, also custom CA and custom Certs
Unexpected end of file from server, server ClickHouseNode(addr=xxxx, db=default)@459021787tried following connection parameters
github.demo.altinity.cloud
8443
demo
demo
1.8.x1671.0.0.20221015NoneLinuxChrome能直观看到数据源中库表信息，不用每次都执行show tables
null
No response
1，进入新建数据源，选择clickhouse，可进行数据源配置
2，关闭数据源配置页，重新打开，数据源配置tab不显示
你好，
工具体验很好，但也存在如下几个问题：
1.管理账号不能直接创建新用户，
2.管理账号不能关闭注册功能，而注册较为简单，是否存在风险？
3. 新注册账号默认拥有User权限，用户权限默认能进行数据查询等操作，有数据泄露风险
4. 数据查询权限要不开放，要不关闭，不能针对部分账号开放
1.通过登录页面直接注册，但存在 2风险？
3通过去掉User的权限，新建权限并授权给需要用户
4.目前看无此功能，是否有解决方案？
No response
查询结果上方加一个筛选框
查询结果上方加一个筛选框
查询结果上方加一个筛选框
server or web themes在editor，即默认生成的第一个编辑框，输入脚本。再新增其他编辑框。再回到Editor，Editor中的脚本就没了。
1
1
1
java --versionnode --ver1sionnpm -v./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -111rt
SELECT * FROM table_a WHERE id = '215' ;
SELECT * FROM table_b WHERE a_id = 215 ;
No response
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.