# Multiple data sources

**URL:** <https://forum.opensearch.org/t/multiple-data-sources/17580>\
**Category:** OpenSearch Dashboards\
**Created:** [January 25, 2024, 7:33am UTC](https://forum.opensearch.org/t/multiple-data-sources/17580 "2024-01-25T07:33:08Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pjanzen](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@pjanzen](https://forum.opensearch.org/u/pjanzen)\
**Post date:** [January 25, 2024, 7:33am UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/1 "2024-01-25T07:33:08Z")

</div>

Hi,

I am running opensearch-dashboards-2.11.1 and opensearch-2.11.1 on a local single node. I have created this setup to test multiple data source in opensearch dashboards.

I have followed [this documentation](https://opensearch.org/docs/latest/dashboards/management/multi-data-sources/) for multi-data-sources and altough the datasource can connect it either gives me 404 errors or json parse errors.

To the remote dashboard url  
https:// osdashb.on.my.host (new users are allow max 2 links)

```auto
"type":"response","@timestamp":"2024-01-25T07:05:19Z","tags":[],"pid":1029671,"method":"get","statusCode":404,"req":{"url":"/_mapping?pretty=true","method":"get","headers":{"x-forwarded-for":"100.107.90.146","host":"osdashb-prd-nl1-vmo.nl1.unified.services","content-length":"0","user-agent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)","content-type":"application/json","x-forwarded-proto":"https","securitytenant":""},"remoteAddress":"100.107.89.146","userAgent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)"},"res":{"statusCode":404,"responseTime":11,"contentLength":9},"message":"GET /_mapping?pretty=true 404 11ms - 9.0B"}

```

Of the url mentioned in the documentation  
ie: https:// osdashb.on.my.host/app/management/opensearch-dashboards/dataSources

```auto
parse@http://my.public.host:5601/6867/bundles/plugin/opensearchUiShared/opensearchUiShared.plugin.js:1:69116
expandLiteralStrings@http://my.public.host:5601/6867/bundles/plugin/opensearchUiShared/opensearchUiShared.plugin.js:1:70930
51/EditorOutputUI/<@http://my.public.host:5601/6867/bundles/plugin/console/console.chunk.2.js:1:319380
os@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:83209
gc@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:102288
__osdSharedDeps__ </t.unstable_runWithPriority@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:443:3844
Xo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45024
bc@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:102047
Qs@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:93596
Vo/<@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45315
__osdSharedDeps__ </t.unstable_runWithPriority@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:443:3844
Xo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45024
Vo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45262
Yo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45195
$s@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:90458
ba@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:62277
51/useSendCurrentRequestToOpenSearch/<@http://my.public.host:5601/6867/bundles/plugin/console/console.chunk.2.js:1:250160

```

Result of test connection is this

```auto
{"type":"response","@timestamp":"2024-01-25T07:30:08Z","tags":[],"pid":1020841,"method":"get","statusCode":200,"req":{"url":"/app/management/opensearch-dashboards/dataSources/","method":"get","headers":{"x-forwarded-for":"100.107.90.146","host":"osdashb-prd-nl1-vmo.nl1.unified.services","user-agent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)","x-forwarded-proto":"https","securitytenant":""},"remoteAddress":"100.107.89.157","userAgent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)"},"res":{"statusCode":200,"responseTime":27,"contentLength":9},"message":"GET /app/management/opensearch-dashboards/dataSources/ 200 27ms - 9.0B"}

```

So I am a bit lost on this feature, am I doing something wrong or is this a bug?

Thanks.  
Paul.

---

<div class="post-metadata">

**Author:** ![huan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/huan/32/639_2.png) [@huan](https://forum.opensearch.org/u/huan)\
**Post date:** [February 7, 2024, 7:01am UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/2 "2024-02-07T07:01:45Z")

</div>

Would you share which page do you see the error

> it either gives me 404 errors or json parse errors.

---

<div class="post-metadata">

**Author:** ![Kruzerson](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/kruzerson/32/5937_2.png) [@Kruzerson](https://forum.opensearch.org/u/Kruzerson)\
**Post date:** [May 8, 2024, 2:24pm UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/3 "2024-05-08T14:24:09Z")

</div>

@pjanzen Did you manage to find a solution to this problem?

---

<div class="post-metadata">

**Author:** ![pjanzen](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@pjanzen](https://forum.opensearch.org/u/pjanzen)\
**Post date:** [May 8, 2024, 4:14pm UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/4 "2024-05-08T16:14:03Z")

</div>

yes I did but I abandoned the solution as it did not what I hoped it did, namely combining dashboard data from different sources. I ended up creating aggregation queries and import the extracted data in to a relational DB and create the dashboards from there.

---

<div class="post-metadata">

**Author:** ![Kruzerson](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/kruzerson/32/5937_2.png) [@Kruzerson](https://forum.opensearch.org/u/Kruzerson)\
**Post date:** [May 9, 2024, 6:36am UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/5 "2024-05-09T06:36:08Z")

</div>

@pjanzen What didn’t work for you is exactly what I need. Please tell me how you connected another cluster to the dashboard.

---

<div class="post-metadata">

**Author:** ![tw-dpd](https://avatars.discourse-cdn.com/v4/letter/t/e9bcb4/32.png) [@tw-dpd](https://forum.opensearch.org/u/tw-dpd)\
**Post date:** [May 15, 2024, 12:44pm UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/6 "2024-05-15T12:44:07Z")

</div>

Hi,

having the same issue here, documentation lacks any example of what to enter for the URL when trying to connect to a remote opensearch cluster, is it 9300/9200/xxx port etc

have tried the above and still no joy, but documentation is lacking here

---

<div class="post-metadata">

**Author:** ![pjanzen](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@pjanzen](https://forum.opensearch.org/u/pjanzen)\
**Post date:** [May 15, 2024, 2:04pm UTC](https://forum.opensearch.org/t/multiple-data-sources/17580/7 "2024-05-15T14:04:18Z")

</div>

In the environment I maintain I have 3 cluster manager node, 3 cluster coordinator nodes and 2 data nodes. In front of the coordinator node there is a loadbalancer vip. The url I type is something like https://\<coordinator\_vip\_address\>:9200/ and I have no seperate user for this. I just use the admin user.