Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Have you opened the IP Address range for AWS from the ODBCIS install location?

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Can you try putting square brackets around the table name, it is possible the query is getting confused with the dot

select name from [Person.CountryRegion]

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?

Hey Edward , that also did not help.

Can you try putting square brackets around the table name, it is possible the query is getting confused with the dot

select name from [Person.CountryRegion]

Hi Phillipe,

Yes it is accessible.

Yes I am using Postman in my local IT environment.

Hi Werner,

Is your computer paengine.rcmnow.com is accessible with these coordinates from the world wilde (from the world aws)?

You use pstman  in your Local IT environment ?

Regards,

Philippe

Hi Phillipe,

The request now works in Postman:

But we are getting the below error in PA:

Hi Philippe , I see that your IP/DNS that is blurred out is different than localhost, are there any additional steps to configure the server to that specific IP/DNS?

How would you test if it is working on local server?

Hi Werner,

I have already make test whith ODBCIS...

Perhaps have a look at https://www.next-decision.fr/wiki/configurer-et-utiliser-des-sources-odbc-pour-planning-analytics-aws

Regards,

Philippe

Hi All for some context we are trying to connect to a SQL server using ODBC connection in Planning analytics engine (v12).

We have installed and started the IBM Planning Analytics ODBC Data Connector.
We have configured the AdventureWorks2019 SQL database with the correct login credentials in the Datasources part of the config.odbcis.json file.
We are not sure if the Client part will be the login to the PAW environment or would it be the same credentials used to login to the SQL database.

When running the following request (IP and Port changed): IP:Port/api/v1/Datasources

We get an error:
{
    "error": {
        "code": "278",
        "message": "'Datasources' resource can not be resolved on type 'EntityContainer'."
    }
}

Are there any other config steps to make the cloud be able to see this such as exposing the port in the firewall config?